Programming a macro to run other macros on each worksheet

Question

I have an excel workbook with many different sheets. Each sheet has a single macro in it wich saves the sheet as a pdf and opens outlook with that pdf as an attachment. I am looking for a function to place on one worksheet that will run each macro without having to manually run each on their respective worksheets.

Answer 1

Say there is a macro in each worksheet called SheetMac. Put the following in a standard module and run it:

Sub MASTER()
For Each sh In Sheets
    sh.Activate
    Call sh.SheetMac
Next sh
End Sub