LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Deleting Pictures

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Deleting pictures from multiple worksheets dford Excel Discussion (Misc queries) 2 December 24th 06 04:43 AM
Excel's Compress Pictures or deleting pictures doesn't seem work guidod Excel Discussion (Misc queries) 1 January 29th 06 06:51 AM
deleting 100's of pictures, keep data jsc3489 Excel Worksheet Functions 0 June 8th 05 07:54 PM
deleting pictures choice[_2_] Excel Programming 2 October 28th 04 02:48 PM
Deleting pictures using VBA?? Richard1284 Excel Programming 3 May 23rd 04 04:19 PM


All times are GMT +1. The time now is 10:54 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"