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

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

Hi ceige7979
As L.Howard Kittle says or more simply:
sub Commandbutton_click()
sub1
sub2
sub3
sub4
sub5
end sub

sub1()
....
end sub
etc.

"ceige7979" wrote:

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

use this idea
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Normek" wrote in message
...
Hi ceige7979
As L.Howard Kittle says or more simply:
sub Commandbutton_click()
sub1
sub2
sub3
sub4
sub5
end sub

sub1()
...
end sub
etc.

"ceige7979" wrote:

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