Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Get Macro to Repeat on Each Worksheet
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Get Macro to Repeat on Each Worksheet
Thanks that worked perfect!
"Jim Rech" wrote: 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to get a macro to repeat | Excel Discussion (Misc queries) | |||
Repeat Macro | Excel Worksheet Functions | |||
Getting a macro to repeat | Excel Discussion (Misc queries) | |||
Repeat a command in a Macro | Excel Discussion (Misc queries) | |||
Macro to repeat formulas in next row | Excel Discussion (Misc queries) |