Tabbing between text boxes and locking all else.

R

Rahn

I have built a user form using Excel 2000, I used the "View - Toolbars -
Control Tool Box - Text Box" to make areas where the user can enter
data. I saved this as a template and when I try to move from one box
to the next using the Tab key, nothing happens, cursur won't move to
the next box. I have to use the mouse to click on the next box to make
it work.

I would also like to make the sheet so that when it is opened up, the
only place you can type are in the text boxes. I tried protecting the
sheet, but that doesn't seem to do what I am looking for. (Unless I am
doing something wrong).

Thanks
 
Top