gimli
04-06-2010, 08:13 AM
Hi,
I am using the following code to limit scrolling for a specific worksheet.
Option Explicit
Private Sub Worksheet_Activate()
Sheet1.ScrollArea = "b1:q27"
End Sub
This code is entered via the worksheet tab. It works fine if I run it manually....shouldnt this run automatically when the workbook is opened since its coded on the worksheet?
any suggestions?
thanks much
I am using the following code to limit scrolling for a specific worksheet.
Option Explicit
Private Sub Worksheet_Activate()
Sheet1.ScrollArea = "b1:q27"
End Sub
This code is entered via the worksheet tab. It works fine if I run it manually....shouldnt this run automatically when the workbook is opened since its coded on the worksheet?
any suggestions?
thanks much