How can I select/delete multiple pictures

[Jim T]

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

[Dave Peterson]

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

--

Dave Peterson

[Dave Peterson]

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

--

Dave Peterson

[Alan]

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.
"Jim T" <abaco8...@yahoo.com> wrote in message
news:ueOv8Vy...@TK2MSFTNGP06.phx.gbl...

[josephm...@gmail.com]

Alan and Dave,

Great advice. Thanks!

[lewisjames...@gmail.com]

A simple solution is in excel 2010 is select 1 image. Predd CTL & 'a' then delete.

That's it..

[bna...@gmail.com]

Awesome, yeah that worked. Where do these pictures come from?

[murru...@gmail.com]

I know this was posted years ago, but it was a major time saver and I REALLY appreciated it. Have a great day and know that your gift keeps on giving.

d

[yfl...@msn.com]

Thanks so much James!

[krystale...@gmail.com]

Alan, YOU ROCK!!! Its so embarassing to admit how much time i spent trying to figure this out. Thanx a Bunch. Its people like you that make my life soo much easier!!!! :)

[priya...@gmail.com]

Great advice! thank you!!
>
> Jim T

[arjun...@gmail.com]

Lewis Mate.. U r a champ.. Thanks..

[duke.ki...@gmail.com]

Try select any picture.
Then, hit Ctrl+A (Windows) Command+A (Mac).
Then, DELETE !!

[shanu...@gmail.com]

wonderful

[devind...@gmail.com]

Thanks to You. Kudos

[mrb...@gmail.com]

Thanks it worked!!! Tried many times to fix this. Appreciate your post/help! M & V

[lee21]

Thank you.. It works great

[maxlan...@gmail.com]

Lewis nailed it, if you have Excel 2010! Easiest way, for sure.

[pcs...@gmail.com]

On Wednesday, November 14, 2007 8:28:43 PM UTC-5, Dave Peterson wrote:
> Can you remove all the pictures?If yes...Open the workbook select that worksheethit alt-f11 to get to the vbe hit ctrl-g to see the immediate windowType this and hit enter: Activesheet.pictures.deleteThis 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.picturesmypict.deletenext mypict end subJim T wrote:> > 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-- Dave Peterson


Dave,

After all these years, not sure you will ever see this, but I want to let everyone knows that I just use your solutuin on Office 2010, and works great. Just did what you said, i.e.,

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

Thanks again! Nader

[ubaidg...@gmail.com]

I have 1000+ pictures in Excel sheet. and want to delete first 758 pictures once a time and other want to remain save. then how it possible to delete picture without selecting Ctrl+Mouse click one by one.

Anybody to resolve the issue

[ubaidg...@gmail.com]

[aduf...@techie.com]

---

Jim,

Take a look at Picture Manager For Excel add-in utility which does remove and insert multiple pictures and to multiple Excels. Check out the video and download at Doality.com

-AD

[gretchen...@gmail.com]

THANK YOUU!!!!!

[joel.d...@gmail.com]

On Sunday, September 1, 2013 9:51:28 AM UTC+2, ubaidg...@gmail.com wrote:
> I have 1000+ pictures in Excel sheet. and want to delete first 758 pictures once a time and other want to remain save. then how it possible to delete picture without selecting Ctrl+Mouse click one by one. Anybody to resolve the issue

You can select multiple objects in a rectangular region. To do this with Excel 2010, click on "Find & Select" to display the sub-menu and then, click on "Select Objects". Then you can trace a rectangular region (by click-down and move mouse) on your Excel sheet, over the pictures you want to select.

[mattm...@gmail.com]

You just saved me hours! Thank you!!!