To the button assign the sub MainOne and click the button. Put your five
codes where the Msgbox code is.

Sub MainOne()
TheNext1
End Sub

Sub TheNext1()
MsgBox "Next1"
TheNext2
End Sub

Sub TheNext2()
MsgBox "Next2"
TheNext3
End Sub

Sub TheNext3()
MsgBox "Next3"
TheNext4
End Sub

Sub TheNext4()
MsgBox "Next4"
TheNext5
End Sub

Sub TheNext5()
MsgBox "That all five folks"
End Sub

HTH
Regards,
Howard

"ceige7979" wrote in message
...
I have 5 seperate macros in one workbook. I want to build one button that
will run them all. I can not use Access I have to use Excel