View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Husker87 Husker87 is offline
external usenet poster
 
Posts: 35
Default 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