Tab Order In Excel?

[FontanaS]

I have a template in excel.
It has some combo boxes and drop down boxes in the spreadsheet itself.

I was wondering if there was a way to only ylet the user in certain cells. Exactly like theway the tab ordering works in access.

I do not want the user to click on the rows between the text boxes. Instead i want the user when they hit enter or tab to go to the next text box or cell that i want.

THANKS!!

 

[plantj]

Format the "user" cells with Protection not Locked then set Protection on for the sheet. Tab will then cycle through the user cells. Unfortunately (perhaps) Enter will not work this way.