How can I run Multiple Modules from another Module

Question

hello, i have 17 modules that i need to run. I want to create a new module that calls all those modules. I have tried the below with and without CALL. All modules are in a book called Fin Macros.xlsm

Sub PRELIM_MasterMacro()

Call PRELIM\_a\_Business\_Operations 

Call PRELIM\_b\_CFO\_Org 

Call PRELIM\_c\_Communications 

Call PRELIM\_d\_COO\_Org 

Call PRELIM\_e\_Construction 

Call PRELIM\_f\_Corp\_Desk 

Call PRELIM\_g\_CPO\_Org 

Call PRELIM\_h\_Credit\_Risk 

Call PRELIM\_i\_DDA 

Call PRELIM\_j\_Executive 

Call PRELIM\_k\_IT 

Call PRELIM\_l\_Legal 

Call PRELIM\_m\_Compliance 

Call PRELIM\_n\_Marketing 

Call PRELIM\_o\_Product\_Mgmt 

Call PRELIM\_p\_Real\_Estate 

Call PRELIM\_q\_Overhead 

End Sub

i get this error on the first call statement. Please help. Thank you!

Answer 1

Make sure that neither the name of the macro (MasterMacro) nor that of any of the macros that you call coincides with the name of a code module in your workbook. (In other words, PRELIM_a_Business_Operations, PRELIM_b_CFO_Org etc. must be the names of macros, not of modules)

Answer 2

Thanks so much MVP! worked great!! not the 1st time you helped me....

I have to name the MACRO the same as the CALL, ,but it had to be different than the module.

Thanks again!!