Delete Images from Spreadsheets
Sub Delete_Images_From_Excel()
Dim sht As Worksheet
Dim shp As Shape
For Each sht In Sheets
For Each shp In sht.Shapes
shp.Delete
Next
Next sht
End Sub
Friday, May 04, 2007
Download Windows Live Toolbar and personalize your Web experience! Add custom buttons to get the information you care about most.
Posts
AWESOME!!! Thank you! Saved me hours of work!
ReplyDeleteNow I can go home! Woohoo!!
Fantastic! I have little images in my spreadsheet for ages I can't get rid of them, now they are all gone. Genius, thanks.
ReplyDeleteThank,ThankThankThankThankThankThankThankThankThankThankThankThankThankThankThank i have no words so say god bless u
ReplyDeleteHi
ReplyDeleteThese codes are deleting all the pictures which is awesome. However I need to delete selected pictures from the worksheet.
Could you please let me know if you have any other codes for this?
Regards,
Sudip