Hoe can I restrict user cursor movement to unlocked cells only ?
Thanks
Hoe can I restrict user cursor movement to unlocked cells only ?
Thanks
If the worksheet is protected (Tools >> Protection) the user will get an error message. The "Lock" option under cell format won't work unless the sheet or book is protected too.
Stacie
Far
Which version of Excel?
Different versions have different options.
2002 and 2003 allow you to select options when you go to
Tools>Protection>Protect 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"
<[email protected]> wrote:
>Hoe can I restrict user cursor movement to unlocked cells only ?
>
>Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks