Create a List of All Shapes

**Mordred** · 09-30-2011, 04:12 PM

Hi all,

How can I make a list of all the shapes I have created in my workbook. There are a couple that I made, stopped using, but never deleted and I don't want them within the workbook anymore.

Regards:

**Winon** · 09-30-2011, 04:38 PM

Hi Mordred,

That is a very good question. Had the same problem many moons ago, but my pc packed up and I was rid of the problem. However, Leith Ross never seizes to amaze me with his programming skills and knowledge ! I am sure he wont mind if you ask him for help. I too, would like to see how it can be resolved. Good Luck!

**shg** · 09-30-2011, 04:42 PM

Please Login or Register  to view this content.

**JBeaucaire** · 09-30-2011, 05:35 PM

If the goal is to delete them, a slight expansion on SHG's macro can offer you that opportunity:

Please Login or Register  to view this content.

**Winon** · 09-30-2011, 05:53 PM

Wow,

An excellent sample of the KISS principle. This Forum Rocks! Keep it up guys!

**shg** · 09-30-2011, 06:15 PM

A slight change to JB's code will let you see what you may be deleting:

Please Login or Register  to view this content.

**Mordred** · 09-30-2011, 08:05 PM

Thanks for the help guys, shg's amendment of Jerry's procedure is a keeper!

**Andy Pope** · 10-01-2011, 09:51 AM

for a vba approach you can use the selection pane.
Home > Editing > Find & Select > Selection Pane.

You can use CTRL+Click to multi select and then delete.