Brian
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:J30"
End Sub
Gord Dibben Excel MVP
On Tue, 30 Nov 2004 18:42:31 -0800, "Jason Morin"
wrote:
Run a macro using:
ThisWorkbook.ActiveSheet.ScrollArea = "A1:J30"
HTH
Jason
Atlanta, GA
-----Original Message-----
Hello,
I the portion of a worksheet that I currently have
positioned so that it is
the only visible part of the sheet. But the scroll bar
and the wheel on the
mouse can be used to move the sheet. What can I do to
lock any scrolling?
Thank You
Brian
.
|