Macro calling macros then not running additional macros?

[bmpreston]

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

 

[bmpreston]

Was that whole previous post not what you were needing?

 

[Fluff]

No, all you showed was what macros were being called.
There was no actual code.
Your best bet is to step through your code as I outlined in my previous post

 

[bmpreston]

So I did just that and it processes all of the 'Burris' including opening, and closing the spreadsheet, and when it returns to the foreground sheet, it just stops on Burris. It never returns to START macro, to process the Garrison macro.

Thanks

 

[Fluff]

When you say

it just stops on Burris

do you mean that the line in red below, is highlighted in yellow?

Sub Start()

[COLOR=#ff0000]Burris[/COLOR]
Garrison
Selesky
Navarre
Ohlenbusch
Preston
Price
Prievo
Stahl
Young
Wilson
Master_Stale

End Sub

 

[bmpreston]

Correct. And no further. Well, actually Stepping into it... It repeats Burris again if I continue to Step-Into...

Everything up to that point, is flawless, including running everything on the Burris Workbook.

Thanks

 

[Fluff]

Could you post the last code run in the Burris file, which from post#8, looks to be the CloseandSave macro.

 

[bmpreston]

Sub CloseandSave()
ActiveWorkbook.Close SaveChanges:=True
End Sub


That's it...

 

[Fluff]

Not sure why that's happening.
This shouldn't make any difference, but worth a shot.
Change your start macro to this & see what happens

Sub Start()

    Call Burris
    MsgBox "Burris done"
    Call Garrison
    MsgBox "Garrison done"
    Selesky
    Navarre
    Ohlenbusch
    Preston
    Price
    Prievo
    Stahl
    Young
    Wilson
    Master_Stale

End Sub

 

[bmpreston]

No dice.

dammed frustrating!

lol

 

[Fluff]

Ok.
Change the CallsendMacros to this

Sub CallSendMacros()
UpdateLinks
HideColumns
apply_autofilter_across_worksheets
MAIL_TO_TECHNICIAN

End Sub

& then change the Start macro to

Sub Start()

    Call Burris
    Workbooks("Michael Burris.xlsm").Close True
    Call Garrison
    Selesky
    Navarre
    Ohlenbusch
    Preston
    Price
    Prievo
    Stahl
    Young
    Wilson
    Master_Stale

End Sub