Controling navagation of a form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

created a form in excel. How do I make it so the client completing the form
can tab through only the cells requiring them to enter information?

As it is now when you hit tab key you move to cells that are background in
the form
 
Read up on protected cells and forms. When you protect the form, all cells
are protected. You'll need to unprotect the cells you want users to enter
information on. If you have 2003, there is a Protection toolbar that is very
handy to use when you unprotect.

Carole O
 
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

Assign Cell to move to 1
Access Access DB Form Limit Hit 0
Using Tab key to jump to specific cell 2
URGENT- Form design and field tab-order problems 5
PDF viewer in Custom Form 0
Cursor Movement 2
CELL ORDER 1
Tabbing through unlocked cells 6

Back
Top