delete all pictures in a worksheet

[toddgak]

How can I use vba do delete all the pictures in a worksheet? Sometimes I have to cut and paste long lists from the internet and there is a picture next to each piece of the list. How can I get rid of all of them? I know I can just paste special and do text, but I would like to know how to get rid of all the pictures using a macro.

[VBA Noob]

Is this a cross post. If it is please add the link

VBA Noob

[toddgak]

Yea, it is.

Here's the link to my other post:

http://www.mrexcel.com/forum/showthread.php?t=367263

[Leith Ross]

Hello toddgak,

Here is a macro to delete the all the pictures on the active worksheet.

Please Login or Register  to view this content.

[shg]

... or

Please Login or Register  to view this content.

[Dan_Gee]

If you don't want to use a macro in Excel 2007, just press F5, press "special", select "objects", and press "okay". All the pictures should now be selected. Just press "delete" now.