VBA to delete all shapes unless a macro is assigned to it

**BillDoor** · 01-22-2016, 10:32 AM

Hi

I have a sheet that has various shapes on it and I want to delete them all, except if the shape has a macro assigned to it
is this possible?
the simple code I'm using right now is just

Please Login or Register  to view this content.

thanks

**StephenR** · 01-22-2016, 10:40 AM

A quick test suggests this works, slightly to my surprise.

Please Login or Register  to view this content.

**YasserKhalil** · 01-22-2016, 10:41 AM

Hi Bill
Try this code

Please Login or Register  to view this content.

To be deleted. I didn't see the Stephen's code ..

VBA to delete all shapes unless a macro is assigned to it

LinkBack

Thread Tools

Rate This Thread

Display

VBA to delete all shapes unless a macro is assigned to it

Re: VBA to delete all shapes unless a macro is assigned to it

Re: VBA to delete all shapes unless a macro is assigned to it

Thread Information

Users Browsing this Thread

Similar Threads

Lagging cursor when hovering over shapes with a macro assigned.

[SOLVED] If shapes exist then delete

[SOLVED] How to delete all Shapes in all WS within a WB

Delete all shapes in specified range with macro

Delete shapes in a range macro not working

Delete Shapes in Range

Delete Shapes Error 400

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions