Setting cell selections in form spreadsheet

  • Thread starter Thread starter kentuckyjo
  • Start date Start date
K

kentuckyjo

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?
 
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
 
Back
Top