Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how do I prevent users to go into locked cells
Hoe can I restrict user cursor movement to unlocked cells only ?
Thanks |
#2
|
|||
|
|||
Far
Which version of Excel? Different versions have different options. 2002 and 2003 allow you to select options when you go to ToolsProtectionProtect Sheet. One of the options is "select locked cells". Uncheck it. One of the options is "select unlocked cells". Check it. If earlier versions, VBA code is required. Gord Dibben Excel MVP On Fri, 11 Feb 2005 12:02:01 -0800, "Farchid" wrote: Hoe can I restrict user cursor movement to unlocked cells only ? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Locked cells not updating | Excel Worksheet Functions | |||
To safety merge cells without data destroyed, and smart unmerge! | Excel Discussion (Misc queries) | |||
Can a cell be locked to prevent being typed over? | Excel Worksheet Functions | |||
Locked cells | Excel Worksheet Functions | |||
Can I hide locked cells? | Excel Worksheet Functions |