Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
problems when removing validation
Hello - I have a spreadsheet with multiple drop down selection boxes all set
up using Data Validation, and all referenceing separate lists. One of them is causeing me problems because the drop down arrow remains visible even when that cell is not selected. If someone tries to use the drop down when the cell is not selected (if they click on the down arrow when the cell is not selected), no list appears as needed. I tried to clear, and reset the data validation for this cell to correct the problem...but the problematic drop down arrow is always visable...even when the data validation is completed cleared. Any ideas on what might be causing this, or how to fix the problem? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
problems when removing validation
I've not seen that problem before myself, so I'm only guessing at a solution
here. What happens if you assign a new (non-drop down) Validation to that cell... does the drop down arrow go away? If so, then try clearing the Validation from that cell... is the arrow still gone? -- Rick (MVP - Excel) "CH" wrote in message ... Hello - I have a spreadsheet with multiple drop down selection boxes all set up using Data Validation, and all referenceing separate lists. One of them is causeing me problems because the drop down arrow remains visible even when that cell is not selected. If someone tries to use the drop down when the cell is not selected (if they click on the down arrow when the cell is not selected), no list appears as needed. I tried to clear, and reset the data validation for this cell to correct the problem...but the problematic drop down arrow is always visable...even when the data validation is completed cleared. Any ideas on what might be causing this, or how to fix the problem? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Removing Data Validation (Listbox) | Excel Worksheet Functions | |||
Reposting -- no response yet -- issue with removing validation in | Excel Programming | |||
validation problems... | Excel Discussion (Misc queries) | |||
Validation Problems | Excel Worksheet Functions | |||
Validation Problems | Excel Programming |