how to navigate through unprotected cells only in a worksheet

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?
 
M

Mike H

Hi,

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

Mike
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Move to next unprotected cell 6
How can I merge unprotected cells in a protected worksheet? 1
Printing Unprotected Cells Only 4
Move to next unprotected cell automatically after entering data 2
Inserting pictures into unprotected range in a protected worksheet 1
Delete unprotected cells in protected worksheet 1
Protect Cells 1
Copying cells in a protected worksheet 2

Top