View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Roger Govier[_3_] Roger Govier[_3_] is offline
external usenet poster
 
Posts: 2,480
Default Validation List arrow visibility

Hi

That is the behaviour with Data Validation, the dropdown only appears in the
Active cell.
Debra Dalgleish has information on her site and suggested workarounds.

http://www.contextures.com/xlDataVal08.html#Freeze

--
Regards
Roger Govier



"robs3131" wrote in message
...
Hi all,

Is there a way to have the arrows for validation lists be made to be
always
visible? The arrow is only visible if a user clicks on the validation
cell.

Thanks!

--
Robert