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? |
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? |
All times are GMT +1. The time now is 09:56 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com