Lock scrolling when worksheet active

[Chickenmanc]

I am using this code and it but only when I click another tab, then click back on the tab.

Private Sub Worksheet_Activate()
     ActiveWindow.Zoom = 107
     Sheets("Main Menu").ScrollArea = "A1:Q32"
End Sub
[Code]


I tried this as well

[Code]
Private Sub Worksheet_Open()
     ActiveWindow.Zoom = 107
     Sheets("Main Menu").ScrollArea = "A1:Q32"
End Sub
[Code]

 

[mrshl9898]

So when do you want it to run?