Setting Tab Order for Text Boxes & Unlocking them

[Debbie]

Is there any way to set a tab order for text boxes in
excel? I have a spreadsheet with many text boxes that I
want users to tab to in a certain order.

Also, I have the sheet protected and I have certain cells
available to the users to input data - How do I make the
text boxes unlocked for users?

 

[Dave Peterson]

Textboxes from the controltoolbox toolbar???

If yes, then Harald Staff posted this:
http://groups.google.com/groups?threadm=#QCLnQ2OBHA.2080@tkmsftngp05

But it sounds like you're using the textbox from the drawing toolbar. (I'd swap
them to make the tab stuff work.)

But you can rightclick on the textbox from the drawing toolbar and choose
format|textbox|Protection and toggle its "locked text" property.