View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jim Rech Jim Rech is offline
external usenet poster
 
Posts: 2,718
Default Get Macro to Repeat on Each Worksheet

Sub DelAllObjs()
Dim WS As Worksheet
For Each WS In Worksheets
WS.DrawingObjects.Delete
Next
End Sub


--
Jim
"rgatto" wrote in message
...
I have a macro I recorded that works in whatever worksheet I'm in to remove
objects. I would like it to work for all worksheets in whatever workbook
I'm
in. Does anyone know how to write that into the macro?

Thanks!