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!
|