Run multiple macros
 

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!

Run multiple macros
 

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.
--
Gary''s Student - gsnu200903


"puiuluipui" wrote:

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!

Run multiple macros
 

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!

"Gary''s Student" wrote:

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.
--
Gary''s Student - gsnu200903


"puiuluipui" wrote:

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!

Run multiple macros
 

Excel knows where the macros are so you don't have to designate modules.

Sub Call_All()
macro1
macro2
macro3
End Sub

On Thu, 17 Sep 2009 08:16:06 -0700, puiuluipui
wrote:

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!

Run multiple macros
 

Hi Gord i understand now. It's working.
Thanks allot!

"Gord Dibben" wrote:

Excel knows where the macros are so you don't have to designate modules.

Sub Call_All()
macro1
macro2
macro3
End Sub

On Thu, 17 Sep 2009 08:16:06 -0700, puiuluipui
wrote:

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!