Leigh

Something like the following in the code module for the sheet with the
button that runs all 13 should work:

Option Explicit

Private Sub CommandButton1_Click()
MsgBox "test 1"
End Sub

Private Sub CommandButton3_Click()
Call CommandButton1_Click
Call Sheet2.CommandButton1_Click
Call Sheet3.CommandButton1_Click
End Sub

You need to make sure the commond button procedures on the sheets
other than the calling sheet are not Private.

Good luck.

Ken
Norfolk, Va


On May 28, 9:53*am, Leigh Douglass
wrote:
Hi

I have 13 individual macros assigned to 13 individual command buttons on 13
separate sheets. *I would like one more command button with a macro that runs
all of the other 13 macros/buttons.

thanks
Leigh