PDA

View Full Version : Validation in cell



austenr
10-19-2005, 08:31 AM
I have created a questionnaire and have added a validation list in a cell at the end of each question for the user to select an answer. The problem is until you select the cell the drop down arrow is not visible. Is there a way to make it stay visible even though it is not selected?

Zack Barresse
10-19-2005, 10:25 AM
Nope. An alternative might be: select all cells with your answers, unprotect them (Ctrl + 1 | Protect | Unprotect), then protect your sheet (only allowing the selection of unlocked cells). This way the only cells they can select the cells you want - the answers in this case - and they always see the drop down (where applicable).

austenr
10-19-2005, 10:28 AM
Thanks Zack. Didn't think I could but it never hurts to ask. Marking solved.