Locate and delete objects

Good morning, Gurus.

In the attached sample workbook, (Excel 2007 format), there are hundreds, maybe thousands, of drawing objects and rectangles. They are mostly located near the top of column AC. You can't see any of them, because they are empty, or formatted to have no line and no fill, ubt if you move the cursor around in that area, it will eventually give you the option to "select" one of the objects. They appear to be stacked on top of each other.

This bloats the worksheet terribly. I have managed to shave the size of the attached sample down to 100K, bu deleting about 200 of the objects, but if I save this balnk file as an Excel 2003 file, it is 1.3 Mb.

I have discovered how to show what objects are on the worksheet, by selecting "Find and Select" and choosing to show the "Selection Pane". This pane shows hundreds of blank objects in the sheet. When this pane is open, however, if I try to select and delete an object, Excel locks up on me.

Is there a way to quickly delete all objects from a worksheet?

Thanks in advance for any help you can offer.

This will clear all Buttons and shapes in the active worksheet.
This happens when rows are deleted but the shapes are not, they end up getting scrunched at the top.

Please Login or Register  to view this content.

hi Hutch,

Yes, in the sample file there were 6706 drawing objects!

Try running this macro...

Please Login or Register  to view this content.

hth
Rob