Data Validation

[Ricki Miles]

I am using Excel 2003. I have several cells using a list for data
validation and would like the drop down arrow for validation to show for
each cell all the time, whether the cell is active or not. Is this
possible?

Thanks,

Ricki

 

[Martin Fishlock]

Ricky,

You could put an image next to the cells with the data validation list.

Then when you activate the cell the proper list is pulled down.

HTHs

Martin Fishlock

 

[Ricki Miles]

Hi Martin,

Thanks for the suggestion. Unfortunately, rows will be inserted/deleted and
columns resized, so your solution will not work as the image will not move
with the changes. Is there programming that will force the arrow to
display?

Thanks,

Ricki