Remove Drawing Objects

jdean

New Member
Joined
Dec 10, 2003
Messages
5
Can anyone tell me how to remove ALL drawing object & pictures
in a spreadsheet, w/o having to click each one & hit "delete"
thanks
 

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.
this would work

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


hth
kevin
 
Upvote 0
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
 
Upvote 0
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
 
Upvote 0
ASAP Utilities (free add-in) has this ability to select all objects, and to delete all objects.
 
Upvote 0
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.
 
Upvote 0
Shades/ Kevin/ All
ASAP did the trick-
excellent freeware (what's the hitch??!!)
thx for your help
 
Upvote 0
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
 
Upvote 0
Mike in Perth
thanks
however, under "Edit" menu, there is no "go to",
therefore no "special" button
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,213,504
Messages
6,114,016
Members
448,543
Latest member
MartinLarkin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top