Excel VBA one macro to run multiple macros not working

[Stuepef]

I want one macro to run several other macros, but when I write the code, I receive a compile error - sub or function not defined. What am I missing?

Sub Runallmacros()    
    Call LYRates
    Call TYRates
    Call DeleteSpaces
End Sub

 

[Fluff]

A few things come to mind.
1) Have you spelt the names correctly?
2) Are all those macros in the same workbook?
3) Are any of them Private Subs?

 

[Stuepef]

Answers to your questions:

1. The names of the macros are spelt accurately
2. The macros are in the same workbook, but spread out across multiple worksheets (ie. Sheet1, Sheet2, Sheet3)
3. None of the macros are private

 

[Fluff]

Do any of the macros have anything in the brackets like

Sub amacro(Rng as Range)

 

[Stuepef]

No, all of the macros have everything outside the brackets (i.e. Sub LYRates () or Sub TYRates () )

 

[Fluff]

but spread out across multiple worksheets (ie. Sheet1, Sheet2, Sheet3)

Sheet module should only really be used for Event code & ActiveX controls.
Try moving the macros into regular modules.

 

[Stuepef]

That was definitely the issue, moved the macros to a module and my code above works. Thank you for the help again!

 

[Fluff]

You're welcome

 

[Stuepef]

One more question, I transferred all the macros in a module, but one macro doesn't run. I checked the spelling and if I run that one macro separate, it runs just fine. Why would it not update when its with the other macros?

 

[Fluff]

Put the word Stop at the beginning of that macro & then run Runallmacros.
Does the VBE open up with the word Stop highlighted in yellow?