Entering data to non protected cells

  • Thread starter Thread starter Kalevi
  • Start date Start date
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
 
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
 
Back
Top