Get Macro to Repeat on Each Worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
Sub DelAllObjs()
Dim WS As Worksheet
For Each WS In Worksheets
WS.DrawingObjects.Delete
Next
End Sub
 
Back
Top