View Single Post
  #2   Report Post  
Debra Dalgleish
 
Posts: n/a
Default

Only the active cell can have the data validation arrow visible.
Perhaps you could colour the cells to highlight them, or add comments to
the cells to mark them.

dfinke wrote:
How do I keep the dropsown list "button" visible even when the cell
associated with the dropdown list is not selected?



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html