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 |
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 |
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 |
All times are GMT +1. The time now is 12:33 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com