Run multiple macros in order

[Dokat]

Hi,

I have 20 macros that i'd like to run in order. I use below code however it returns Compile Error: Sub or Function not defined pop up window. What may cause this issue? Thanks

Sub RUN()

    Call WBC
    Call WBA
    Call WRO
    Call WGI
    Call WFP
    Call WGP
    Call WMP
    Call MPM
    Call MTM
    Call MHI
    Call MDW
    Call CFP
    Call CPE
    Call CWC
    Call RBO
    Call RPE
    Call RTA
    Call OSA
    Call VBA
    Call VSA

End Sub

 

[Joe4]

If you hit "Debug", which line of code is highlighted?

Do all of these procedures exist in Standard/General Modules, or in specific sheet modules?
Do the all exist in the same module?
Are they marked Public or Private?

Also, NEVER use reserved words like "Run" or "VBA" for the names of procedures (reserved words are words that are already used by Excel/VBA in names of functions, properties, methods, etc).
Doing so can cause errors or unexpected results.

 

[Dokat]

If you hit "Debug", which line of code is highlighted?

Do all of these procedures exist in Standard/General Modules, or in specific sheet modules?
Do the all exist in the same module?
Are they marked Public or Private?

Also, NEVER use reserved words like "Run" or "VBA" for the names of procedures (reserved words are words that are already used by Excel/VBA in names of functions, properties, methods, etc).
Doing so can cause errors or unexpected results.

When i debug it highlights "Sub RunAllMacros()" in yellow.

Yes they are all in the sheet("Summary" and they are not private

 

[Joe4]

Try moving all code to a General/Standard module, and move it out of the "Summary" sheet module.

If that does not work, then start from the ground up.
Comment out ALL of the macros it is calling, except for the first one.
Does that work?
If not, what if you try running that one macro, directly. Does that work?

Once you get the first one to work, then uncomment out the second one, and test again.
Keep repeating this process until all are working.

 

[Dokat]

Try moving all code to a General/Standard module, and move it out of the "Summary" sheet module.

If that does not work, then start from the ground up.
Comment out ALL of the macros it is calling, except for the first one.
Does that work?
If not, what if you try running that one macro, directly. Does that work?

Once you get the first one to work, then uncomment out the second one, and test again.
Keep repeating this process until all are working.

I am really confused. I am still getting the same error message. Please see attached image of the error.

 

[Dokat]

Try moving all code to a General/Standard module, and move it out of the "Summary" sheet module.

If that does not work, then start from the ground up.
Comment out ALL of the macros it is calling, except for the first one.
Does that work?
If not, what if you try running that one macro, directly. Does that work?

Once you get the first one to work, then uncomment out the second one, and test again.
Keep repeating this process until all are working.

There was a typo in the in the macro names i corrected it and it seems to be working. But it is taking too long to run. Its been 10 mins and its still going

 

[Joe4]

But it is taking too long to run. Its been 10 mins and its still going

That could mean that your individual macro code is inefficient and needs to be fixed up.
You haven't posted any of it, so we cannot make that determination of offer any suggestions.