how to navigate through unprotected cells only in a worksheet
 

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?

how to navigate through unprotected cells only in a worksheet
 

Hi,

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

Mike

"VictorO" wrote:

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?

how to navigate through unprotected cells only in a worksheet
 

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 ToolsProtection.


Gord Dibben MS Excel MVP

On Thu, 23 Oct 2008 11:35:01 -0700, VictorO
wrote:

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?