Disappearing Data Validation arrows

[Mike Lewis]

I have several cells with "drop down list" Data
Validation. When I first start Excel, they always work as
designed. After a while, using some VBA macros, they
disappear. The data validation conditions still work, but
the drop down arrows are gone. I have to restart Excel to
make them appear again.

Can anyone suggest a place to start to trouble shoot this
problem. I suspect there is some VBA code that causes the
problem, but don't know where to start.

I am familiar with the previous problem with "frozen
windows" and arrows. There are no frozen windows in this
application.

I am using Excel 2000.

Thanks.

Mike

 

[Debra Dalgleish]

I've seen some problems with data validation dropdowns when cells are
merged in the worksheet. Perhaps your macros are doing that.

 

[Gord Dibben]

One more point....Does one of your macros change the Objects view in
Tools>Options>View to "Hide All"?

Gord Dibben Excel MVP