Setting Tab Order for Text Boxes & Unlocking them

  • Thread starter Thread starter Debbie
  • Start date Start date
D

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?
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Tab Order between Cells and Text Boxes 1
Excel Move or Copy Stopped Working? 0
ENTER skips unlocked cells 3
Tabbing through Text Boxes in Excel 2002 1
Protected Worksheet Tab Order 1
Bypass unlocked cell on protected worksheet in Excel 2003? 8
How do i setup tabbing order of cells? 8
Tabbing through unlocked cells 6

Back
Top