ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I control fields tabbed to on protected sheet? (https://www.excelbanter.com/excel-discussion-misc-queries/109293-how-do-i-control-fields-tabbed-protected-sheet.html)

Stamper

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?

curlydave

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?



Bob Phillips

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?




JLatham

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?



All times are GMT +1. The time now is 04:50 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com