MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Control selecting protected cells

Posted by Jim on December 04, 2001 6:12 AM

With most cells protected, is there a way to make the cursor (active cell) jump to the next unprotected cell rather than moving down or right per option setting when enter, tab or arrow keys are pressed (or mouse clicked)? In other words, the user wouldn't even be able to select a protected cell. Thanks for any help.

Posted by Paul on December 04, 2001 6:29 AM

use the tab key, it will only go to unprotected cells