Entering data to non protected cells

K

Kalevi

If I protect the table I can still "stop" at any cell and get the message if
trying to enter data to protected area. My Q here is. can you avoid this
being able to click on any cell and instead just jump to a non protected
cell and to the next and next?
Thanks
Kalevi
 
A

Airfive

Hi,
Use the "Tab" key to jump directly to unlocked cells. Your worksheet will
have to be in protected mode for this to work.

HTH
Ron
 

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

Top