macro for running other macro

[pippo100]

How cam i write a macro for running 3 others macro?
Thank you
By

 

[Guest]

As long as they're all in the same Module just put in the name of the other macros in that one, VBA will do the rest
Else if there in the same project you have to qualify the whole name

Private Sub RunMacros(
Macro
Macro
Macro
End Su

----- pippo100 > wrote: ----

How cam i write a macro for running 3 others macro
Thank yo
By

 

[SunTzuComm]

If the macros you want to run are in the same workbook, just call them:

Sub Main_Macro()
Call Some_Other_Macro1
Call Some_Other_Macro2
End Sub

Sub Some_Other_Macro1()
. . .
End Sub

Sub Some_Other_Macro2()
. . .
End Sub

If a macro is in a different workbook, use the Application.Run method:

Application.Run _
"Other_Workbook.xls!Other_Macro"

Regards,
Wes