Linking subs into one macro

[Julie]

I want to be able to push one button and have the macro run two separate
subs, one after the other. Does anyone know how to do this?

** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Software!
http://www.ozgrid.com/Services/excel-software-categories.htm **

 

[Trevor Shuttleworth]

Julie

Sub Macro1()
Macro2
Macro3
End Sub

Sub Macro2()
: code for Macro 2
End Sub

Sub Macro3()
: code for Macro 3
End Sub

Regards

Trevor

 

[Bill Kuunders]

add a line at the bottom of your first sub with just the name -no brackets-
of your second sub

Sub firstone()
does it's thing...
secondone
End Sub
Regards
Bill K