| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Run multiple macros
Hi, is there any way i can run multiple macros located in diferent modules?
I want to have a button assigned to a macro and when i click it, the multiple macro to run the macro in module 1, then the macro in module 2, then the macro in module 3.... Can this be done? Thanks! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Run multiple macros
Have the button connected to something like:
Sub MAIN() Call Mac1 Call Mac2 Call Mac3 ....... End Sub As long as the Mac's are not Private, you should be O.K. -- Gary''s Student - gsnu200903 "puiuluipui" wrote: Hi, is there any way i can run multiple macros located in diferent modules? I want to have a button assigned to a macro and when i click it, the multiple macro to run the macro in module 1, then the macro in module 2, then the macro in module 3.... Can this be done? Thanks! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Run multiple macros
Hi Gary,
"As long as the Mac's are not Private, you should be O.K." I don't know so much to understand exactly what this refer to, but i receive an error: Compile error: Sub or Function not defined. I have 4 modules. Module1 Module2 Module3 Main Main module has your code. What am i doing wrong? Thanks! "Gary''s Student" wrote: Have the button connected to something like: Sub MAIN() Call Mac1 Call Mac2 Call Mac3 ...... End Sub As long as the Mac's are not Private, you should be O.K. -- Gary''s Student - gsnu200903 "puiuluipui" wrote: Hi, is there any way i can run multiple macros located in diferent modules? I want to have a button assigned to a macro and when i click it, the multiple macro to run the macro in module 1, then the macro in module 2, then the macro in module 3.... Can this be done? Thanks! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Run multiple macros
Excel knows where the macros are so you don't have to designate modules.
Sub Call_All() macro1 macro2 macro3 End Sub On Thu, 17 Sep 2009 08:16:06 -0700, puiuluipui wrote: Hi, is there any way i can run multiple macros located in diferent modules? I want to have a button assigned to a macro and when i click it, the multiple macro to run the macro in module 1, then the macro in module 2, then the macro in module 3.... Can this be done? Thanks! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Run multiple macros
Hi Gord i understand now. It's working.
Thanks allot! "Gord Dibben" wrote: Excel knows where the macros are so you don't have to designate modules. Sub Call_All() macro1 macro2 macro3 End Sub On Thu, 17 Sep 2009 08:16:06 -0700, puiuluipui wrote: Hi, is there any way i can run multiple macros located in diferent modules? I want to have a button assigned to a macro and when i click it, the multiple macro to run the macro in module 1, then the macro in module 2, then the macro in module 3.... Can this be done? Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using Macros To Perform Multiple Averages | Excel Worksheet Functions | |||
| Run macros on data spread across multiple spreadsheets | Excel Discussion (Misc queries) | |||
| Message box with multiple options running different macros | Excel Discussion (Misc queries) | |||
| Using Multiple Tests and Sounds With Worksheet Macros | Excel Discussion (Misc queries) | |||
| creating macros in multiple worksheets | Excel Worksheet Functions | |||
Hybrid Mode
