Solved

Clear Picture

Posted on 2014-01-21
2
261 Views
Last Modified: 2014-01-21
Hello, how do i code in vba a macro that will go to sheet 17 and delete only the shapes labled Picture 19 and Picture 22.
0
Comment
Question by:sandramac
2 Comments
 
LVL 81

Accepted Solution

by:
zorvek (Kevin Jones) earned 500 total points
ID: 39798897
Public Sub DeletePictures()
   
    On Error Resume Next
    With Worksheets("Sheet 17")
        .Shapes("Picture 19").Delete
        .Shapes("Picture 22").Delete
    End With

End Sub

Kevin
0
 

Author Closing Comment

by:sandramac
ID: 39798948
Thanks
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

821 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question