Disappearing Data Validation arrows

  • Thread starter Thread starter Mike Lewis
  • Start date Start date
M

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
 
I've seen some problems with data validation dropdowns when cells are
merged in the worksheet. Perhaps your macros are doing that.
 
One more point....Does one of your macros change the Objects view in
Tools>Options>View to "Hide All"?

Gord Dibben Excel MVP
 
Back
Top