View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
via135 via OfficeKB.com via135 via OfficeKB.com is offline
external usenet poster
 
Posts: 30
Default removing objects..!

yes..!

it works like a charm..!
thanks Luke..!

-via135


Luke M wrote:
Could you use a short macro like:

Sub RemoveShapes
For Each sh In ActiveSheet.Shapes
sh.Delete
Next
End Sub
hi all.!

[quoted text clipped - 10 lines]

-via135


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/201003/1