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

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" wrote in message
...
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

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

"Martin Fishlock" wrote in message
...
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" wrote in message
...
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