How can I select/delete multiple pictures

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jim T - 15 Nov 2007 01:18 GMT

I just discovered some of my spreadsheets have hundreds of pictures in them.
Most are just a pixel at a cell intersection. I figured out where they
originated and will prevent more from showing up, but I am stuck with around
400 pictures in this spreadsheet.

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.

Jim T

Reply to this Message

Dave Peterson - 15 Nov 2007 01:28 GMT

Can you remove all the pictures?

If yes...

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:
Activesheet.pictures.delete

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:

Option Explicit
Sub testme()
dim myPict as picture
for each mypict in activesheet.pictures
mypict.delete
next mypict
end sub

> I just discovered some of my spreadsheets have hundreds of pictures in them.
> Most are just a pixel at a cell intersection. I figured out where they
[quoted text clipped - 8 lines]
>
> Jim T

Signature

Dave Peterson

Reply to this Message

Dave Peterson - 15 Nov 2007 01:30 GMT

ps...

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

> Can you remove all the pictures?
>
[quoted text clipped - 36 lines]
>
> Dave Peterson

Signature

Dave Peterson

Reply to this Message

Alan - 15 Nov 2007 01:32 GMT

Pictures are objects, so if you go onto 'Edit' > 'Goto' > click 'Special' on
the bottom left, select 'Objects' and hit delete, they will all be deleted.
Problem is that graphs etc are also objects so if you have anything like
that in the sheet they will be deleted too. Best way is to make a copy of
the file and experiment on that.
Regards,
Alan.

>I just discovered some of my spreadsheets have hundreds of pictures in
>them. Most are just a pixel at a cell intersection. I figured out where
[quoted text clipped - 8 lines]
>
> Jim T

Reply to this Message

Rate this thread: