Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run all macros in module with one command
Is there a way to call/run all macros in a module with one command? I
have many modules with 7 Subs/macros in them and would like to run them with one line rather than 7 lines. Is it possible? How would I proceed, maybe some kind of loop? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run all macros in module with one command
Create a master macro in the standard code module1.
Sub Master() macro1 macro2 macro3 macro4 macro5 macro6 macro7 'Any cleanup code End Sub Then you only have to initiate the master procedure which will call the other procedures. "pwk" wrote: Is there a way to call/run all macros in a module with one command? I have many modules with 7 Subs/macros in them and would like to run them with one line rather than 7 lines. Is it possible? How would I proceed, maybe some kind of loop? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2 Macros running on same module | Excel Worksheet Functions | |||
Command button to run macro in a module | Excel Programming | |||
command button for vba module | Excel Programming | |||
MoveAfterReturn command fails in Worksheet module | Excel Programming | |||
Two Macros-One Module | Excel Discussion (Misc queries) |