Help with tab in Excel

[Mike Busch]

I would like to setup a spreadsheet like a form, and have users tab from one
cell to the next, (not in the same row or column) only selecting the next
cell that needs data entered into it, and skipping all in between. Entering
data and then going to the next cell that would need to be populated. I
remember doing this previously, but forgot.

 

[Luke M]

Under format cell, protection tab, unlock all the cells that you want the
user to fill out. Then, protect the worksheet, allowing users to only select
unprotected cells.

 

[Gord Dibben]

Cell locking/unlocking and sheet protection will allow tabbing to unlocked
cells but only in a left to right pattern.

Is that OK with you?

If not in that pattern you could use a named range or VBA

For how to use a named range method see Bob Phillips' site.

http://www.xldynamic.com/source/xld.xlFAQ0008.html

For VBA post back.


Gord Dibben MS Excel MVP