Run all macros in module with one command

P

pwk

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?
 
J

JLGWhiz

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top