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
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
ASKER
Thanks Roya! Let me see what I can do..
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
Click your right mouse on the listbox and set IntegralHeight to FALSE
Dave
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Okay working on it now!
ASKER
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!
I would suggest that you use code to resize the controls in the activate event of the worksheet.