tab to next unprotected cell ON PAGE 1 ONLY

G

Guest

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
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Tab Key 1
Excel - How to get tab to go to next unlocked cell across columns 3
Protected Cell 4
Setting cell selections in form spreadsheet 1
Merged cells withing Protected Sheets 3
Tab Through worksheet 2
lock only one cell 4
Protected sheet, On Enter moves next. Can I stop this? 3

Top