Entering data to non protected cells
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 "Kalevi" wrote: 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 |
All times are GMT +1. The time now is 01:19 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com