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!
|