how do I prevent users to go into locked cells

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

Guest

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

Thanks
 
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
 
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
protect formulas in locked cells from changing if data is moved 3
Is it possible to protect cell formatting in an unlocked cell? 2
Lock CELLS 2

Back
Top