Very simple ? on setting up tab order
 

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!

Very simple ? on setting up tab order
 

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

then protect the sheet.

--
Regards,
Tom Ogilvy


"Justine" wrote in message
...
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!

Very simple ? on setting up tab order
 

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?

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Very simple ? on setting up tab order
 

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!

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Very simple ? on setting up tab order
 

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.

--
Regards,
Tom Ogilvy

"Justine Wolfley" wrote in message
...
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!

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!