| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| work with multiple workbooks on separate monitor for 2003 edition | Excel Worksheet Functions | |||
| macro copy/paste data from multiple cells to multiple cells | Excel Discussion (Misc queries) | |||
| Excel's Compress Pictures or deleting pictures doesn't seem work | Excel Discussion (Misc queries) | |||
| Adding multiple worksheets | Excel Worksheet Functions | |||
| Deleting a rows from multiple worksheets | Excel Worksheet Functions | |||
Linear Mode
