Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 76
  • Last Modified:

Excel 2013 VBA - Delete all pictures from a sheet

Dear Experts,

I have a file which contains a lot of small pictures, could you please advise which VBA code could delete all of them from the sheet?

Thanks in advance,
0
csehz
Asked:
csehz
  • 2
2 Solutions
 
Rob HensonFinance AnalystCommented:
Is it all Objects on the sheet that are to be deleted?

If so:

ActiveSheet.DrawingObjects.Select
Selection.Delete

Thanks
Rob H
0
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
Only this is suffice...

Sub DeletePictures()
ActiveSheet.DrawingObjects.Delete
End Sub

Open in new window

0
 
csehzIT consultantAuthor Commented:
Thanks very much
0
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
You're welcome. Glad to help.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now