Deleting Multiple Images

[A.S.]

Is there a macro that can delete images? I am copying and pasting info from a
website and images from that site are also copied. I cannot delete the row as
the images still remain there...is there a macro I can use that will get rid
of all the images?

Thanks.

[Dave Peterson]

Ron de Bruin has lots of sample code:
http://www.rondebruin.nl/controlsobjectsworksheet.htm

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

A.S. wrote:
>
> Is there a macro that can delete images? I am copying and pasting info from a
> website and images from that site are also copied. I cannot delete the row as
> the images still remain there...is there a macro I can use that will get rid
> of all the images?
>
> Thanks.

--

Dave Peterson

[Jaleel]

Hi,

Press F5. "Go To" box will open. Press "Special". Check 'Objects". Then
delete.
Won't it work Dave?

Jaleel


"Dave Peterson" wrote:

> Ron de Bruin has lots of sample code:
> http://www.rondebruin.nl/controlsobjectsworksheet.htm
>
> If you're new to macros, you may want to read David McRitchie's intro at:
> http://www.mvps.org/dmcritchie/excel/getstarted.htm
>
> A.S. wrote:
> >
> > Is there a macro that can delete images? I am copying and pasting info from a
> > website and images from that site are also copied. I cannot delete the row as
> > the images still remain there...is there a macro I can use that will get rid
> > of all the images?
> >
> > Thanks.
>
> --
>
> Dave Peterson
>

[Dave Peterson]

It depends...

Does the OP want to delete all the shapes?

Jaleel wrote:
>
> Hi,
>
> Press F5. "Go To" box will open. Press "Special". Check 'Objects". Then
> delete.
> Won't it work Dave?
>
> Jaleel
>
>
> "Dave Peterson" wrote:
>
> > Ron de Bruin has lots of sample code:
> > http://www.rondebruin.nl/controlsobjectsworksheet.htm
> >
> > If you're new to macros, you may want to read David McRitchie's intro at:
> > http://www.mvps.org/dmcritchie/excel/getstarted.htm
> >
> > A.S. wrote:
> > >
> > > Is there a macro that can delete images? I am copying and pasting info from a
> > > website and images from that site are also copied. I cannot delete the row as
> > > the images still remain there...is there a macro I can use that will get rid
> > > of all the images?
> > >
> > > Thanks.
> >
> > --
> >
> > Dave Peterson
> >

--

Dave Peterson

[viziworld]

Please Login or Register  to view this content.

[arlu1201]

viziworld,

Welcome to the forum.

I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. In order to put code tags, either type [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] at the end of it, OR you can highlight your code and click the # icon at the top of your post window.

Also this is a 7 yr old thread, not likely to help the original poster but it may help others.