Reset ScrollArea

  • Thread starter Thread starter Hennie Neuhoff
  • Start date Start date
H

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?
 
Set this property to the empty string ("") to enable cell selection for the
entire sheet.

Sheets(1).ScrollArea = ""
 
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
 
Back
Top