Hi, coal_miner,
I would suggest as follows:
*** assume the 'Drop Down List' is in Cell I10.
1. Catch a 'print-screen' of the small arrow button.
2. Paste ithe exactly over the original 'drop-down list' button.
3. Write a short Macro:
=============
Sub Show_Drop_Down_I10()
[I10].Select
SendKeys "%{down}" ' emulates Alt+Down Arrow
End Sub
=======
Allocate that Mcro to the Picture.
*** Click on the Picture and..... voil* !
Michael Avidan - ISRAEL
http://forums.tapuz.co.il/office
"coal_miner" wrote:
Thank you for your help Debra.
"Debra Dalgleish" wrote:
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.
coal_miner wrote:
Greetings. First off, let me thank anyone in advance for taking the time to
assist me. My question should be easy to answer. I have setup some drop
down lists in one of my worksheets. The button with the arrow that opens the
list hides itself after I click on another cell. How can I keep that button
always showing? Thanks again. Cheers.
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html