| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I control fields tabbed to on protected sheet?
How do I jump from desired field to desired field on a protected worksheet
form? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I control fields tabbed to on protected sheet?
Do you want to go to another range to input data in a protected sheet??
is this what you are asking? Stamper wrote: How do I jump from desired field to desired field on a protected worksheet form? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I control fields tabbed to on protected sheet?
If those fields are unlocked, that will be your tab order.
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Stamper" wrote in message ... How do I jump from desired field to desired field on a protected worksheet form? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I control fields tabbed to on protected sheet?
IF you are talking about a worksheet rather than a user form, you can make it
tab from unprotected cell to unprotected cell by clearing the box next to the "Select Locked Cells" option when you Protect the sheet. Tab or Enter will then take you to the next unlocked cell. Whether the next move is to the right, left, up or down is controlled by Options, [Edit] tab, "Move direction after Enter" option on that tab. "Stamper" wrote: How do I jump from desired field to desired field on a protected worksheet form? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| macro | Excel Discussion (Misc queries) | |||
| Enable check box in protected sheet + group check boxes | Excel Discussion (Misc queries) | |||
| Down arrow moves cursor to top of worksheet when sheet protected | Excel Worksheet Functions | |||
| Mouse pointer becomes hyperlink when sheet protected | Excel Discussion (Misc queries) | |||
| How do i enable "Group" & "Ungroup" in a protected sheet | Excel Discussion (Misc queries) | |||
Linear Mode
