ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Deleting Multiple Images (https://www.excelbanter.com/excel-discussion-misc-queries/105293-deleting-multiple-images.html)

A.S.

Deleting Multiple Images
 
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

Deleting Multiple Images
 
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

Deleting Multiple Images
 
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

Deleting Multiple Images
 
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


All times are GMT +1. The time now is 07:38 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com