Picture Won't Delete

[negcx]

I am working with a spreadsheet created by a predecessor and there is a picture at the top of one of the worksheets. When I select the picture and hit Delete, it seems to work, but the picture is still there. When I move it around the worksheet and resize it, a copy with the same name ("Picture 47") remains in the spot I moved it from. When I delete the resized/moved picture, it deletes, but the picture still remains in the original spot.

When I record a macro and select the picture and hit delete - or even when I move the picture and resize it - the recorded macro is blank.

Any ideas? All of the pictures seem to be named "Picture 47"

[shg]

Maybe there are multiple copies of the picture stacked one above the other?

Post the workbook if you can.

[negcx]

It's possible but highly unlikely - I've deleted it at least fifty times. I would suspect the picture would have different names if that was the case, but I'm not intimately familiar with Excel object naming conventions.

I have attached an example workbook.

Is there some way to write a macro to just loop through all picture objects and delete them?

Thanks,
negcx

[VBA Noob]

By pressing Alt + f5 > special > select objects > delete that should delete all objects.

There seems to be a few objects on the sheet

VBA Noob

[shg]

Dunno.

Execute these two lines in the immediate window:

activesheet.shapes.selectall
selection.delete

[negcx]

Thanks a lot shg, that worked. I just have no idea what was going on...

[shg]

You're welcome.

Noob's suggestion would have done the same.