Very simple ? on setting up tab order

[Justine]

I created a very simple calculator in Excel and locked
down all but the few input fields. Can someone then tell
me how to limit tabbing or entering to just those input
fields? I don't want the user to hit tab and go way off
to the right where I placed some hidden tables, or to
enter down to a locked blank field where if they attempt
to type will get the "This workbook is protected..."
message. This is probably a very simple setting but I
can't for the life of me find any help on it. Thanks!

 

[Tom Ogilvy]

lock all cells, then unlock those you want the user to be able to edit
(format=>Cells=>Protection Tab)

then protect the sheet.

 

[Justine Wolfley]

Thank you for the quick reply.
I have already locked the cells, and this works great to prevent
unwanted typing in other cells. But my question was really about setting
a tab order, such as if user types in the first input field and hits
enter I want to specify where the cursor goes as I have several input
fields on different rows and columns. Is this possible?

 

[Justine Wolfley]

Oh my gosh! I just figured it out. Upon protecting the workbook if I
select Allow User to: Select unlocked cells only then when they hit
enter or tab they go down the list of unlocked cells and skip the locked
cells in order. Wow! That is really cool. Thanks again!

 

[Tom Ogilvy]

Just note that that setting is not retained if you close the workbook and
reopen it. You will need to use the workbook open event to set the
enableselection property.