| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Lock Screen to current view
All,
on and auto_open routine I want to stop the user from being able to scroll left and right as is contains data that I do not want them to have asscess to. How can I stop them from scrolling right & left? TIA Chris |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Lock Screen to current view
Chris,
Look at the .ScrollArea property of the worksheet. Sheet needs to be protected for this to have an effect (I believe). Also, I don't think this is a retained property, i.e. you have to set it each time WS is opened. NickHK "Chris" wrote in message ... All, on and auto_open routine I want to stop the user from being able to scroll left and right as is contains data that I do not want them to have asscess to. How can I stop them from scrolling right & left? TIA Chris |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| view excel in full screen view | Excel Worksheet Functions | |||
| HOW FIX EXCEL WHERE PRINT VIEW IS DIFFERENT FROM SCREEN VIEW | Excel Discussion (Misc queries) | |||
| How to lock a legend on screen | Excel Discussion (Misc queries) | |||
| Lock Screen | Excel Discussion (Misc queries) | |||
| Lock in current date | Excel Discussion (Misc queries) | |||
Linear Mode
