Locked spreadsheet, move cursor only to unlocked cells?

G

Guest

Have created a form in excel that has unlocked cells for data entry.
Would like the cursor to only move to cells that are not locked, skipping
locked cells.
 
S

SteveG

Tools>Protection>Protect Sheet. In the options list, deselect "Select
locked cells".


Cheers,

Steve
 

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

Tab Key 1
I can still select & manipulate locked & protected cells in '07 1
Why is AutoSum iinoperable w/protection when column is unlocked? 2
locking cells dynamically 1
Lock Unlock Cell Protection 2
Viewing of protected locked or unlocked cells 2
Array formula lock-up 1
Inserting comments 3

Top