drop-down button to remain visible

D

Didier Rousselle

I want the drop down buttons I created to remain visible enve nwhen the
cursor is not located at their addresses. What should I do? The drop down
button only appear when the cursor arrives on the cell activated by the
button.
Thanks in advance
 
B

Bob Umlas, Excel MVP

If you must have a data validation type dropdown, then you're out of luck. If
you must have the arrow showing, use a combobox. You might consider
conditionally formatting the cell to be red when empty so that if not used
it'd be obvious that data is needed. To do that, color it red, and
conditionally color it white when the cell is empty (Len(A1)=0 if A1 is the
cell in question).
HTH
 
Top