Run Macro on All Sheets Q
wrote:
I have a macro that runs a routine on the active sheet,
but how would I create a macro that will run this macro
on 'all' sheets expect sheet1 & sheet4?
I would prefer to create a new macro and call the original
macro from within, so that I have the option to run individually
Sub looper
Dim ws As Worksheet
For Each ws in Sheets
ws.Activate
call originalMacro
Next
End Sub
|