Modules to worksheets and workbooks

[bobkap]

I have a workbook with 4 worksheets. I created a macro that works in one of the 4 worksheets. How do I get that same macro to work in all 4?

 

[VoG]

Maybe like this

Dim ws As Worksheet
For Each ws In ActiveWorkbook.Worksheets
    ws.Select
    Call mymacro
Next ws

 

[Andrew Poulsom]

If it's Worksheet event code, the Workbook has events that operate on all the worksheets within it. For example this:

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)

in the ThisWorkbook module, is equivalent to:

Private Sub Worksheet_Change(ByVal Target As Range)

in a Worksheet module.