Run multiple macros

  • Thread starter Thread starter puiuluipui
  • Start date Start date
P

puiuluipui

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!
 
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.
 
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!
 
Excel knows where the macros are so you don't have to designate modules.

Sub Call_All()
macro1
macro2
macro3
End Sub
 
Back
Top