Posted to microsoft.public.excel.misc

Husker87

external usenet poster

Posts: 35

How can I delete several Autoshapes from a speadsheet at once?

Thanks for the reply... ended up using "EditGo To SpecialObjectsOK
then Delete"

Thanks again.

"Gary''s Student" wrote:

Run this small macro:

Sub no_pic()
Dim sh As Shape
For Each sh In ActiveSheet.Shapes
sh.Delete
Next
End Sub

--
Gary''s Student - gsnu200721

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel Speadsheet	$T3V3	Excel Discussion (Misc queries)	1	March 6th 07 08:23 PM
delete multiple autoshapes or objects in excel	ron	Excel Discussion (Misc queries)	3	January 26th 06 03:01 PM
possible to merge a calender with speadsheet	leungjac	Excel Discussion (Misc queries)	0	September 1st 05 08:19 PM
speadsheet protection	jaci	Excel Discussion (Misc queries)	1	August 31st 05 11:05 PM
My speadsheet won't change out of Read Only - Help!!	Shelley Parkin	Excel Discussion (Misc queries)	3	June 15th 05 01:58 AM

All times are GMT +1. The time now is 07:51 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us