Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
drop-down button to remain visible
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
drop-down button to remain visible
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 "Didier Rousselle" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I make a drop down box visible within a worksheet? | Excel Worksheet Functions | |||
Filter drop-down is not visible | New Users to Excel | |||
how do i make all choices in a drop down box visible | Excel Discussion (Misc queries) | |||
Command Button Always Visible in window | Excel Discussion (Misc queries) | |||
how do I keep the dropdown list button visible continuously | Excel Worksheet Functions |