Delete hundreds thousands of objects

[dandelion]

Hi,

I have a file that include hundreds thousands of objects. I have tried 02 ways to delete them but the excel freeze
1. Go to Special --> select Object --> click Delete --> excel Freeze
2. Show Selection Panel --> select some Objects --> excel Freeze before I want to delete.

Anyone can help? TIA

 

[Joe4]

It sounds like you have too many object to select and freeze all at once.

I cannot imagine a workbook with that many objects!
To me, that is a big red flag that you may not be using the right tools for the job at hand.
I cannot imagine it is a very effecient workbook. Is it pretty slow/cumbersome?

 

[shift-del]

1. Go to Special --> select Object --> click Delete --> excel Freeze

It is probably not a "final" freeze but a "just wait for an hour before all objects are deleted" freeze.

 

[Domenic]

If you want to delete them all you can try using a single line of code that you enter in the Immediate Window of the Visual Basic Editor. For example, first open your Visual Basic Editor using F11, then bring up the Immediate Window using Ctrl+G, if it's not already showing, and then make sure that the sheet containing your objects is the active sheet and enter the following line in the Immediate Window and press ENTER...

ActiveSheet.DrawingObjects.Delete

Hope this helps!

 

[dandelion]

If you want to delete them all you can try using a single line of code that you enter in the Immediate Window of the Visual Basic Editor. For example, first open your Visual Basic Editor using F11, then bring up the Immediate Window using Ctrl+G, if it's not already showing, and then make sure that the sheet containing your objects is the active sheet and enter the following line in the Immediate Window and press ENTER...

ActiveSheet.DrawingObjects.Delete

Hope this helps!

Perfect!