If the dropdown is from Data ValidationList you cannot do this.

Either use a ComboBox instead or add a colored triangle to the cell using
the Drawing Toolbar.


Gord Dibben MS Excel MVP

On Tue, 6 Jan 2009 05:02:01 -0800, drose
wrote:

I am try to make a drop down box indicator display itself all the time