Paul
Hiding the unused rows and columns then protecting the sheet is the usual
method.
Setting the scrollarea using VBA is another method.
Note: Setting ScrollArea is good for that session only and only the
activesheet. Has to be reset next time workbook is opened.
Best to place the code into a WorkBook_Open Sub in ThisWorkbook module and
specify which worksheet.
Private Sub WorkBook_Open()
Sheets("YourSheet").ScrollArea = "A1:P60"
End Sub
Gord Dibben Excel MVP
On Tue, 20 Sep 2005 20:17:47 GMT, "Paul Dusterhoft"
wrote:
How do you set the Scroll Area on a worksheet so that the ability to move
around the sheet is limited to the selected area?
|