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. |
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 |
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 |
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