Excel 2000 ActiveX Controls disappear

  • Thread starter Thread starter Roger
  • Start date Start date
R

Roger

Occasionally, one or more ActiveX controls (command
buttons, combo boxes) disappear from an Excel 2000
spreadsheet when AutoFilter is turned off. The control is
actually deleted from the sheet. The reason seems to be
that the control mistakenly gets placed on the list of
objects that need to be removed when AutoFilter is turned
off. (When AutoFilter is turned on, a uniquely named
dropdown is placed at the top of each data column and the
name of each dropdown is placed on a list of objects that
need to be deleted when AutoFilter is turned off again.
Apparantly, other objects on the sheet sometimes get
mistakenly placed on this list of objects to be deleted.
When AutoFilter is turned off, those objects get deleted
along with the AutoFilter dropdowns.)

Does anyone know of a patch or solution of any kind for
this problem?

Thanks in advance for your help!

Roger
 
Hi Roger
this very same problem has been driving me potty.

I have a solution! I created another sheet, copied all objects and
code to the new sheet, and hey presto everything works correctly.

I assume the sheet had become corrupt in some way.

Regards
Brigzy
 
Back
Top