Unable to delete Images. (Ghost Images!)

[Craig_C]

Hi All,

I have a large excel file with multiple TABS and various formulas all working to update a main summary page. On that page there were images that I deleted. However, every time I save and re-open the file, the images re-appear. They can not be clicked on and cannot be deleted. I have tried the following fixes:

a) Go to objects on the sheet (excel says there isn't any)
b) Add a new TAB or click on / off problematic tab. This works, and the images disappear but only until I save and re-open.
c) Searched for picture lookup, but there are no external links
d) Check VBA - nothing appears out of the ordinary, but then I am still understanding VBA so I may have missed something here.

Does anyone have any ideas on a way to rid them completely (other than recreate the whole file)

Thanks in advance,

 

[LazyBug]

In case it's still up to date... Run with active main worksheet:

Sub DelImages()
Dim p
    For Each p In ActiveSheet.Shapes
        If p.Type = msoPicture Then p.Delete
    Next p
End Sub

 

[NdNoviceHlp]

Maybe it should be...

If p.Type = msoPicture Or p.Type = msoLinkedPicture Then p.Delete

HTH. Dave