Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Prevent wandering users
Is there a way that I can 'lock' a sheet to prevent users from scrolling to
the right or down the page? I'd like to keep them on the form I've created and not let them move to the right or down at all. thanks ~cr |
#2
|
|||
|
|||
If you hide all columns to the right and all rows below, the user can only
move around within the visible cells. You would need to protect the worksheet so that can't change the hidden status. On Wed, 5 Oct 2005 11:46:09 -0700, cindee wrote: Is there a way that I can 'lock' a sheet to prevent users from scrolling to the right or down the page? I'd like to keep them on the form I've created and not let them move to the right or down at all. thanks ~cr |
#3
|
|||
|
|||
Tools | Protect Sheet (and limit users to selecting "Unlocked" cells only)
Make sure you've formatted the cells they're allowed to edit to "Unlock" them... "cindee" wrote: Is there a way that I can 'lock' a sheet to prevent users from scrolling to the right or down the page? I'd like to keep them on the form I've created and not let them move to the right or down at all. thanks ~cr |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I prevent users to delete a worksheet, but allow to edit? | Excel Discussion (Misc queries) | |||
Prevent users from copying worksheets | Excel Discussion (Misc queries) | |||
prevent users from overwriting other users data | Excel Worksheet Functions | |||
Protecting Workbook | Excel Discussion (Misc queries) | |||
How do you prevent users from pasting over validated cells? | Excel Discussion (Misc queries) |