Macro to clear all images?
 

Hi all, I have a quick question..keep in mind my vba skills are basic..
How could I tell excel to delete all images in a worksheet without
refencing each one specifically? Just swipe the slate clean of whatever
pictures are present without deleting numbers and such in the sheet..
Any ideas? :)


--
grahamhurlburt
------------------------------------------------------------------------
grahamhurlburt's Profile: http://www.excelforum.com/member.php...o&userid=29878
View this thread: http://www.excelforum.com/showthread...hreadid=554404

Macro to clear all images?
 

Hi Graham,

Try:

'=============
Public Sub Tester()
ActiveSheet.Pictures.Delete
End Sub
'<<=============


--
Regards,
Norman


"grahamhurlburt"
<grahamhurlburt.29sdbn_1150950303.4073@excelforu m-nospam.com wrote in
message news:grahamhurlburt.29sdbn_1150950303.4073@excelfo rum-nospam.com...

Hi all, I have a quick question..keep in mind my vba skills are basic..
How could I tell excel to delete all images in a worksheet without
refencing each one specifically? Just swipe the slate clean of whatever
pictures are present without deleting numbers and such in the sheet..
Any ideas? :)


--
grahamhurlburt
------------------------------------------------------------------------
grahamhurlburt's Profile:
http://www.excelforum.com/member.php...o&userid=29878
View this thread: http://www.excelforum.com/showthread...hreadid=554404