View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JLGWhiz JLGWhiz is offline
external usenet poster
 
Posts: 3,986
Default Reset ScrollArea

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

Sheets(1).ScrollArea = ""

"Hennie Neuhoff" wrote:

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?
--
HJN