Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a large Excel spreadsheet with about 2000 pictures. I am writing a
VBA script to delete all of the pictures. the problem is identifying the ones to delete. If I Set myexcelworkbook = ActiveWorkbook then look in local windows, "Myexcelworkbook", "ActiveSheet", "Shapes" - I only get a list of 256 shapes with the names ranging "Picture 3" to Picture 259". What happend to the almost 2000 other pictures. I recorded macro and selected several and I have quite a few in the "Picture 2009" range. Am I looking the the wrong place to find the picture names so I can delete each one? Or better yet, is there an easier way to delete all pictures on my excel spreatsheet? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Deleting pictures from multiple worksheets | Excel Discussion (Misc queries) | |||
Excel's Compress Pictures or deleting pictures doesn't seem work | Excel Discussion (Misc queries) | |||
deleting 100's of pictures, keep data | Excel Worksheet Functions | |||
deleting pictures | Excel Programming | |||
Deleting pictures using VBA?? | Excel Programming |