How do I control fields tabbed to on protected sheet?

C

curlydave

Do you want to go to another range to input data in a protected sheet??
is this what you are asking?
 
B

Bob Phillips

If those fields are unlocked, that will be your tab order.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
J

JLatham

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