Hi Experts, I'm in excel 2007 experiencing a weird issue.
Please open the attached workbook.
Please try clicking any of the navigation buttons. You'll see that as you navigate between sheets a box will appear highlighting the used range before switching worksheets. That is because of the following code to set the zoom on each sheet:
Private Sub Workbook_SheetActivate(ByVal Sh As Object)
'set zoom for active sheet to columns with data
ActiveWindow.Zoom = True: ActiveWindow.VisibleRange(1, 1).Select
Now what's odd is that on Workbook_Open I have set ScreenUpdating equal to false see the below code:
Private Sub Workbook_Open()
Application.ScreenUpdating = False
I've discovered that if I add another Application.ScreenUpdating
= False statement to the zoom code it will work....... but why would I have to set it to false twice? Is it being set to true after Workbook Open somehow?