We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Now what's odd is that on Workbook_Open I have set ScreenUpdating equal to false see the below code:
Private Sub Workbook_SheetActivate(ByVal Sh As Object) 'set zoom for active sheet to columns with data ActiveSheet.UsedRange.Resize(ActiveSheet.UsedRange.Columns.Count).Select ActiveWindow.Zoom = True: ActiveWindow.VisibleRange(1, 1).Select End Sub
I've discovered that if I add another Application.ScreenUpdating
Private Sub Workbook_Open() Application.ScreenUpdating = False Call FormatWorkbook 'activate StandardMode Sheets("StandardMode").Activate End Sub
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.