Excel: How to get listboxes to not autosize

Experts.  This a related question to a previous post.  I am having an issue with the auto sizing of my listboxes.  Every time I runa a macro to switch sheets, I notice that if I go back the list boxes have shrunk considerable.  In each sheet I had a auto zoom script but I have taken that out to troubleshoot.  Still even without it same issues arises.

Any thoughts? I would still like to have the auto zoom in the spreadsheet

This was the code for the opening of the page , then I added the code to the sheets (Modified)

Private Sub Workbook_Open()
    Range("A1:AD56").Select
    ActiveWindow.Zoom = True
    Range("D2:L3").Select
End Sub


Happy Friday!

 NOC-Reports-r10.xlsm
Maliki HassaniAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
dlmilleConnect With a Mentor Commented:
The change is here.  I played with this for a while so I think its your solution, but try to make it break from here.

Dave
NOC-Reports-r11.xlsm
0
 
Rory ArchibaldCommented:
If they are activex listboxes, then they have a tendency to display that sort of behaviour, particularly when the window zoom is not 100%. Activex controls on worksheets are generally a bit buggy.
I would suggest that you use code to resize the controls in the activate event of the worksheet.
0
 
Maliki HassaniAuthor Commented:
Thanks Roya!  Let me see what I can do..
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
dlmilleCommented:
See Here:  http://www.blog.methodsinexcel.co.uk/2006/08/14/list-box-resizing-problems/

Click your right mouse on the listbox and set IntegralHeight to FALSE

Dave
0
 
Maliki HassaniAuthor Commented:
Okay working on it now!
0
 
Maliki HassaniAuthor Commented:
Good to go!  works like a charm..  I have been working on another design.  I ran into a minor issue though..  Closing this one..  Thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.