Setting cell selections in form spreadsheet
 

I am trying to get my tab button to jump to the unlocked cells only so that
the user can go straight to the cells that they need to populate on my form
created in Excel. Can anyone help?

Setting cell selections in form spreadsheet
 

Lock all cells except the ones you want to Tab into.

Protect the worksheet.

Tabbing will move you across then down then across.

If not in that order post back.


Gord Dibben MS Excel MVP

On Tue, 9 Jun 2009 19:23:01 -0700, kentuckyjo
wrote:

I am trying to get my tab button to jump to the unlocked cells only so that
the user can go straight to the cells that they need to populate on my form
created in Excel. Can anyone help?