Good afternoon.

Using Excel 97 SR2 with Win98 SE.

I have a workbook containing one worksheet where the shapes are
disappearing. There are no shapes from the Control Box Toolbar. There
is a combination of 6 TextBoxes, 6 Spinners, 13 Checkboxes, 18
Buttons, 1 Drop Down, and 2 Comments that are a constant (always on
the worksheet).

On a daily basis, I programmatically delete and add comments (this
varies day to day, but on average about 15 comments). I also use the
AutoFilter facility frequently.

Using a routine that enumerates the shapes in a given worksheet, I
have ascertained that the shapes are not becoming "not visible"; that
they are being deleted.

I have rebuilt this file once already (about a year ago) from scratch
(created new data and objects; absolutely no transfers from the old
file to the new file).

Using the routine that enumerates the shapes in a given worksheet, I
find that the AutoFilter Drop Downs numbering increases with each
AutoFilter usage (whether done programmatically or manually) and that
the numbering is maxing out at the 65545 level (or thereabouts). E.g.
"Drop Down 65545" (maxed out unsigned integer?).

Is there a method to deal with this is so that I don't have to create
another file? Is there a way to prevent this from reoccurring?

Many thanks in advance for any suggestions

Paul Sardella