So I have multiple macros to keep things clean. It may be extra macros but it help in case files change etc.
I have a master 'CallMacros' macro assigned to a button
Clicking this button, calls 11 macros, let's call them Macro1, Macro2, Macro3, etc.
Each macro is:
Workbooks.open (a predefined sheet, each macro1, macro2 calls a corresponding sheet)
Application.run (Calls a macro in each of the above sheets, some of the basic functions of these macros are to update links, save, email, and close that file...)
BUT, it stops after macro1. Macro2 never runs. It never completes the CallMacro...
Any help?
Thanks
I have a master 'CallMacros' macro assigned to a button
Clicking this button, calls 11 macros, let's call them Macro1, Macro2, Macro3, etc.
Each macro is:
Workbooks.open (a predefined sheet, each macro1, macro2 calls a corresponding sheet)
Application.run (Calls a macro in each of the above sheets, some of the basic functions of these macros are to update links, save, email, and close that file...)
BUT, it stops after macro1. Macro2 never runs. It never completes the CallMacro...
Any help?
Thanks