problems when removing validation

C

CH

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?
 
R

Rick Rothstein

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?
 

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

Top