Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

deleting pictures

Status
Not open for further replies.
rgandy

rgandy

Technical User
Nov 17, 2005
38
US
i have a workbook with a bunch of pictures

they are either being labeled by excel as freeform, object or picture

how can i cycle through these and delete them without hitting control objects (ie. dropdowns)

is there a simple way? thanks
 
Sort by date Sort by votes
Code: 
Dim S As Shape

For Each S In ActiveSheet.Shapes
    S.Select
    Selection.Delete
Next

I hope this helps.

Ron Repp

If gray hair is a sign of wisdom, then I'm a genius.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

MattGreer
  • Locked
  • Question
VBA Code Deleting a Column instead of Rows...
Replies
6
Views
146
SkipVought
S
PWD
  • Locked
  • Question
Deleting Columns and Making Sure The Used Range Shrinks Accordingly 2
Replies
15
Views
309
kjv1611
kjv1611
Deniall
  • Locked
  • Question
Deleting an unlocked merged cell on a protected worksheet 1
Replies
4
Views
54
SkipVought
S
PWD
  • Locked
  • Question
Excel Chart - Deleting Source Worksheets 1
Replies
11
Views
60
PWD
PWD
Sbbunno
  • Locked
  • Question
Identifying duplicates based off two values and deleting rows? 1
Replies
6
Views
32
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top