Get Macro to Repeat on Each Worksheet

R

rgatto

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

Jim Rech

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