Reset ScrollArea

[Hennie Neuhoff]

In an efFort to limit user movement on a sheet, I played around with various
options. The following was one of the options:
ActiveWorkbook.Worksheets("SpuitIns").ScrollArea = "A1:N53"
My problem is I can't "reset" the sheet, apart from increasing the scroll
area.
Surely there's some instruction that will reset the sheet to unlimited
movement, I can't find it?

 

[JLGWhiz]

Set this property to the empty string ("") to enable cell selection for the
entire sheet.

Sheets(1).ScrollArea = ""

 

[john]

from helpfile:

Remarks
Set this property to the empty string ("") to enable cell selection for the
entire sheet.

Example
This example sets the scroll area for worksheet one.

Worksheets(1).ScrollArea = "a1:f10"

hope helpful