Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I've set up a protected Excel template with locked cells so users can tab to
the cells that need to be filled in. I have five columns in which they wanted to have a drop down list so they can select the appropriate heading for each column. Once you tab to the last of these columns with the drop down list, the next tab takes you to the first of these five columns instead of going to the next cell to be filled in. You can click into the next unlocked cell, but I'd rather have the users still be able to tab to the next unlocked cell. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
paste locked cells and unlocked cells in protected sheet | Excel Worksheet Functions | |||
HOW TO DELETE MULTIPLE TEXT BOXES FROM A TEMPLATE FILE | Excel Discussion (Misc queries) | |||
Selecting subsets using combo boxes or list boxes | Excel Discussion (Misc queries) | |||
Questions on combo boxes and list boxes. | New Users to Excel | |||
Put comments on a locked spreadsheet even though cells not locked | Excel Worksheet Functions |