Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reset ScrollArea
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reset 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 -- jb "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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ScrollArea : How I can do that | Excel Programming | |||
ScrollArea | Excel Discussion (Misc queries) | |||
Scrollarea | Excel Discussion (Misc queries) | |||
ScrollArea | Excel Programming | |||
do I need ScrollArea and/or?? | Excel Programming |