Worksheet activate not happening when workbook first opens

[ElvisSteel]

Hi,

I have a workbook where the sheets are all protected and I want to stop users scrolling up or across beyond the limits of the input areas.
I have used the following code (or variations of)...

Private Sub Worksheet_Activate()
Me.ScrollArea = "A1:G32"
End Sub

This works fine except that when I first open the workbook, the first sheet displayed can still be scrolled. As soon as you move to another sheet and then back again, it is then OK.

It appears that the Worksheet_Activate code does not execute when the workbook is first opened.

How do I get round this?

Thanks

 

[ElvisSteel]

Rory,

Thanks for taking time to reply, but I think the ScrollArea setting is lost when you reopen the workbook

 

[RoryA]

Just goes to show how often I've used that! Sorry about that.