ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Run all macros in module with one command (https://www.excelbanter.com/excel-programming/424143-run-all-macros-module-one-command.html)

PWK

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?

JLGWhiz

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