Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro for running other macro
How cam i write a macro for running 3 others macro?
Thank you By -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro for running other macro
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 -- Message posted from http://www.ExcelForum.com |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro for running other macro
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Disable running of SelectionChange macro when in another macro? | Excel Discussion (Misc queries) | |||
Event Macro running another macro inside | Excel Discussion (Misc queries) | |||
disable user running macro from Tools Macro | Excel Discussion (Misc queries) | |||
running a macro ina workbook that doesnt have that macro | Excel Programming | |||
Launch Macro in Access via Macro running in Excel??? | Excel Programming |