Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Delete unprotected cells in protected worksheet | Excel Worksheet Functions | |||
Navigate in a big worksheet | Excel Discussion (Misc queries) | |||
How can I have formatting toolbar active for the unprotected(unlocked) cells of the protected worksheet??? | Excel Discussion (Misc queries) | |||
Protected worksheet with unprotected cells i.c.w. remarks | Excel Worksheet Functions | |||
Move cursor through all unprotected cells in a protected worksheet | Excel Discussion (Misc queries) |