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()
ActiveWindow.Zoom = True