how to navigate through unprotected cells only in a worksheet

  • Thread starter Thread starter VictorO
  • Start date Start date
V

VictorO

I have created a template in a work sheet that contains only a few variables
that need information to be enter by the user. How do I get the user (with
the TAB Key or any other key) to move from unprotected cell to unprotected
cell skiping protected cells in between?
 
Hi,

When you protect the sheet make sure the option that allows user to select
protected cells is un-checked.

Mike
 
If your cell sequencing is left to right and top to bottom, simply unlock
the cells you wish to move to.

Lock all others and Protect the Sheet under Tools>Protection.


Gord Dibben MS Excel MVP
 
Back
Top