| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Scroll Lock for selected multiple sheets
Help please,
I'm trying to limit the scroll area of several sheets but I also need other sheets to scroll normally. I'm using this formula in the VBA (ThisWorkbook): Private Sub WorkBook_Open() Sheets("Jan").ScrollArea = "A1:M52" End Sub This works fine for the "Jan" sheet but I have several others that I need to limit the scroll area as well. I tried placing the above formula in each sheet that I want to limit but upon opening the workbook I get an Runtime Error. What's the solution? K |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I turn scroll lock off (2007 excel)? No scroll lock key | Excel Discussion (Misc queries) | |||
| Warning Message (at open) if Multiple Sheets are Selected | Excel Discussion (Misc queries) | |||
| how do I undo the scroll lock, thscroll lock button does not work | Excel Discussion (Misc queries) | |||
| How do I undo an action when multiple sheets are selected? | Excel Worksheet Functions | |||
| Multiple sheets selected | Excel Discussion (Misc queries) | |||
Threaded Mode
