Running a macro from a different module

[kyrgyzstanart]

Hello!

I have got 2 modules (one per procedure) in the same project and would like to make the first Marco run right after the second one is over.

The workbook is open and will be active when the second marco finishes.

Thx!

[shg]

Please Login or Register  to view this content.

[kyrgyzstanart]

Please Login or Register  to view this content.

Thank you! What's important to note is that the Module Name containing any of the two macros (Macro1 or Macro2) should be different from the names of these macros - otherwise there will be an error saying:

Compile error:
Expected variable or procedure, not module

Which means to me that you cannot run a module from a different module, can anyone confirm?

[shg]

It means don't give a module the same name as a procedure.