How to kill ALL copied pictures?
 

Hi,

I've been copying-in dozens of pages of html into excel and, with them,
hundreds of thousands of little "spacer" images. When their links break
they show up as annoying little dots.

My question is, is there any way to do a global kill on images in an
Excel doc? "Delete all images?" Any other like remedies would be
greatly appreciated... except comments of, "Don't break the links."
Trust me, the links will be broken no matter how I deliver the project.


They show up as "Picture 546," "Picture 129," etc. Maybe a
find-and-replace thwack?

THANKS
CORY


--
johncory
------------------------------------------------------------------------
johncory's Profile: http://www.excelforum.com/member.php...o&userid=28507
View this thread: http://www.excelforum.com/showthread...hreadid=481008

How to kill ALL copied pictures?
 

Try this: (assuming there are no graphic objects that you want to
keep)

Go to Edit Go to click on the button marked Special and then choose
Objects

Click OK

You now have all objects on the sheet selected. Hit the Delete key
and they're gone.


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=481008

How to kill ALL copied pictures?
 

Cutter, you rule.

THANKS
CORY


--
johncory
------------------------------------------------------------------------
johncory's Profile: http://www.excelforum.com/member.php...o&userid=28507
View this thread: http://www.excelforum.com/showthread...hreadid=481008

How to kill ALL copied pictures?
 

My wife disagrees! (and so does my daughter)

But thanks anyway, and you're welcome.


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=481008