Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Controling navagation of a form
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 |
#2
|
|||
|
|||
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 "Amanda" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there a way to convert a EXCEL form into a WORD form? | Excel Discussion (Misc queries) | |||
Is there a way to convert a EXCEL form into a WORD form? | Excel Discussion (Misc queries) | |||
Data Form Deletions | Excel Discussion (Misc queries) | |||
Input Form vba help | Excel Discussion (Misc queries) | |||
Trying to delete form border, and it deletes all borders | Excel Discussion (Misc queries) |