selecting freeforms

[maxdv]

i am using the following code to select a freeform and delete it

Please Login or Register  to view this content.

that works fine

i would now like to select and delete ALL freeforms in my worksheet.

they all have different numbers and i don't know beforehand which numbers they have as they are randomly created by some other code

any suggestions?

[blane245]

Welcome to the forum! Try this out. It loops thorugh all of the shapes on the sheet and removes those whose name starts with "Freeform". If you need to remove Freeform shapes from imbedded charts, let me know.

Please Login or Register  to view this content.