How can I select all pictures and delete? I do not have any pictures that
should be in this sheet. I have trouble even seeing these things, let alone
selecting and deleting several hundred of them one at a time.
Thanks in advance.
Open the workbook
select that worksheet
hit alt-f11 to get to the vbe
hit ctrl-g to see the immediate window
Type this and hit enter:
This will fail if the number of pictures is too large (and I don't recall what
that limit is).
But you could use a macro:
dim myPict as picture
for each mypict in activesheet.pictures
If you're new to macros, you may want to read David McRitchie's intro at: