how do I prevent users to go into locked cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I restrict user cursor movement to unlocked cells only ?

Thanks
 
One way would be to select the cell you want to provide access to, go to
Format>Cells and on the Protection page remove the check for "Locked". Then
got to Tools>Protection>Protect Sheet to activate protection with/without
password. Users will still be able to "point to" but not select anything
other tha the unlocked cells.

If using Excel '03 (not sure about XP), you can also use the
Tools>Protection>Allow Users to Edit Ranges feature if more appropriate.

Hope this is useful |:>)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how do I prevent users to go into locked cells 1
Locked cells are still able to be selected with proper protection 1
How unlock locked cells 2
Locked Several Worksheets, allow format cells/select unlocked cell 2
David Biddulph is correct 8
Locking a format 1
protect formulas in locked cells from changing if data is moved 3
Is it possible to protect cell formatting in an unlocked cell? 2

Back
Top