View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Gord Dibben[_2_] Gord Dibben[_2_] is offline
external usenet poster
 
Posts: 621
Default Run Macro on All Sheets Q

Sub looper()
Dim ws As Worksheet
For Each ws In Sheets
If ws.Name < "Sheet1" And ws.Name < "Sheet3" Then
ws.Activate
Call Original Macro
End If
Next
End Sub


Gord

On Fri, 30 Aug 2013 12:40:13 -0700 (PDT),
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