+ Reply to Thread
Results 1 to 6 of 6

Need to delete all pics in a worksheet

  1. #1
    Registered User
    Join Date
    01-21-2009
    Location
    Ridgecrest, CA
    MS-Off Ver
    Excel 2003
    Posts
    4

    Need to delete all pics in a worksheet

    I am absolutely new to visual basic thing but have a good idea of what I am doing in excel. I have seen some code to delete pics but can't figure out what it is that I am suppose to do. What I am doing is coping and pasting something from the internet. I do not need any of the pics that are pasted into the worksheet and am tired of deleting them individualy. Can someone PLEASE break this down barney style for me. It would be greatly appreciated.

    Hopefully this question makes sense.
    Last edited by moe171; 01-21-2009 at 04:56 AM. Reason: Solved

  2. #2
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492
    Press Alt-F11 to open the VBEditor
    Choose Insert > Module
    Paste this code into the open window:
    Please Login or Register  to view this content.
    Press Alt-F11 again to close the Editor.
    Save your sheet.

    Now run the macro:
    Press Alt-F8
    Select DeleteAllPics
    Run

    (Code Source)

    Alternate code:
    Please Login or Register  to view this content.
    (Code Source)
    Last edited by JBeaucaire; 01-21-2009 at 04:34 AM.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

  3. #3
    Registered User
    Join Date
    01-21-2009
    Location
    Ridgecrest, CA
    MS-Off Ver
    Excel 2003
    Posts
    4
    Thank you so much you just saved me alot of time.



    Quote Originally Posted by JBeaucaire View Post
    Press Alt-F11 to open the VBEditor
    Choose Insert > Module
    Paste this code into the open window:
    Please Login or Register  to view this content.
    Press Alt-F11 again to close the Editor.
    Save your sheet.

    Now run the macro:
    Press Alt-F8
    Select DeleteAllPics
    Run

    (Code Source)

    Alternate code:
    Please Login or Register  to view this content.
    (Code Source)

  4. #4
    Registered User
    Join Date
    01-21-2009
    Location
    Ridgecrest, CA
    MS-Off Ver
    Excel 2003
    Posts
    4
    Is there a code to remove all hyperlinks.

  5. #5
    Registered User
    Join Date
    01-21-2009
    Location
    Bagngalore
    MS-Off Ver
    Excel 2003
    Posts
    4
    i worked it in macros for excel

    thanks

    i would like to learn more skills in macro programming for Excel

    can u plz help me. requested

  6. #6
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492
    Quote Originally Posted by moe171 View Post
    Thank you so much you just saved me alot of time.
    If that takes care of your need, be sure to EDIT your original post (Go Advanced) and mark the PREFIX box [SOLVED]

    Put your followup questions in another thread with appropriate titles.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1