Page 1 of 2 12 LastLast
Results 1 to 10 of 13

Remove Drawing Objects

This is a discussion on Remove Drawing Objects within the Excel Questions forums, part of the Question Forums category; Can anyone tell me how to remove ALL drawing object & pictures in a spreadsheet, w/o having to click each ...

  1. #1
    New Member
    Join Date
    Dec 2003
    Posts
    5

    Default Remove Drawing Objects

    Can anyone tell me how to remove ALL drawing object & pictures
    in a spreadsheet, w/o having to click each one & hit "delete"
    thanks

  2. #2
    Board Regular kskinne's Avatar
    Join Date
    Feb 2002
    Location
    USA
    Posts
    1,263

    Default Re: Remove Drawing Objects

    this would work

    Code:
    Sub test()
    For Each s In ActiveSheet.Shapes
        s.Delete
    Next
    End Sub

    hth
    kevin

  3. #3
    New Member
    Join Date
    Dec 2003
    Posts
    5

    Default Re: Remove Drawing Objects

    sorry-
    I was looking for a way to remove all drawing objects & pictures from
    a spreadsheet WITHOUT going into visual basic-
    by use of buttons or commands in excel itself, not a vb editor-
    thanks

  4. #4
    Board Regular kskinne's Avatar
    Join Date
    Feb 2002
    Location
    USA
    Posts
    1,263

    Default Re: Remove Drawing Objects

    it think vba is going to be the only way to automatically do what you are asking with one button-click. why not just create a command button and assign this macro to it?


    kevin

  5. #5
    Board Regular shades's Avatar
    Join Date
    Mar 2002
    Location
    Near the Land of Oz
    Posts
    1,550

    Default Re: Remove Drawing Objects

    ASAP Utilities (free add-in) has this ability to select all objects, and to delete all objects.
    - old, slow, and confused
    ... but at least I'm inconsistent -

    (retired Excel 2003 user, 3.28.2008)

  6. #6
    Board Regular Cbrine's Avatar
    Join Date
    Dec 2003
    Location
    Brampton
    Posts
    3,191

    Default Re: Remove Drawing Objects

    Just activate your drawing toolbar, and press the arrow pointer. This changes your pointer to a drawing pointer. You should be able to highlight all of the drawing objects just by draw a rectangle around them and pressing delete.

  7. #7
    New Member
    Join Date
    Dec 2003
    Posts
    5

    Default Re: Remove Drawing Objects

    Shades/ Kevin/ All
    ASAP did the trick-
    excellent freeware (what's the hitch??!!)
    thx for your help

  8. #8
    Board Regular
    Join Date
    Jun 2002
    Location
    Perth, Australia
    Posts
    1,416

    Default Re: Remove Drawing Objects

    JDean,

    Using just Excel:

    Edit menu | Go to
    Click the Special button
    Click the radio button for Objects
    OK
    (all the objects on the worksheet should be highlighted)
    Hit the delete button on the keyboard.

    Regards,


    Mike

  9. #9
    New Member
    Join Date
    Dec 2003
    Posts
    5

    Default

    Mike in Perth
    thanks
    however, under "Edit" menu, there is no "go to",
    therefore no "special" button

  10. #10
    Board Regular
    Join Date
    Jun 2002
    Location
    Perth, Australia
    Posts
    1,416

    Default Re: Remove Drawing Objects

    JDean,

    In Excel XP, there is definitely a “Go to” menu item under the Edit menu (third last item). I recollect the same with Excel 97. Try function key 5 or Ctrl-G (hold down the Ctrl key and then hit the G key on your keyboard).

    Regards,

    Mike

Page 1 of 2 12 LastLast

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com