tab to next unprotected cell ON PAGE 1 ONLY

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Gina - 24 Feb 2007 20:10 GMT

Hi...I have created my form on excel and have the correct cells locked and
unlocked so the user can use the tab button to get to the next area for
input. My issue however is my form is in columns A-H and the when using tab
it will take me to cells in I-Z before going to the next cell where input
needs to go. Is there a way to only tab between the unlocked cells on p.1 of
the sheet? I hope this makes sense.
Thank you very much for your time. Gina

Reply to this Message

Gord Dibben - 24 Feb 2007 21:19 GMT

Gina

Unprotect the worksheet.

CTRL + a(twice in 2003) to select all cells.

Format>Cells>Protection. Checkmark "locked"

Now select the individual cells or columns you want to Tab to(A:H?)

Format>Cells>Protection. Uncheck "locked"

Now Tools>Protection>Protect sheet.

Gord Dibben MS Excel MVP

>Hi...I have created my form on excel and have the correct cells locked and
>unlocked so the user can use the tab button to get to the next area for
[quoted text clipped - 3 lines]
>the sheet? I hope this makes sense.
>Thank you very much for your time. Gina

Reply to this Message