Macro calling macros then not running additional macros?

bmpreston

Board Regular
Joined
Jun 18, 2016
Messages
120
Office Version
  1. 365
Platform
  1. MacOS
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
 
This works. This is incredible. Thanks so much.

Ok.
Change the CallsendMacros to this
Code:
Sub CallSendMacros()
UpdateLinks
HideColumns
apply_autofilter_across_worksheets
MAIL_TO_TECHNICIAN

End Sub
& then change the Start macro to
Code:
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
 
Upvote 0

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.
Glad to help & thanks for the feedback
 
Upvote 0

Forum statistics

Threads
1,216,106
Messages
6,128,863
Members
449,473
Latest member
soumyahalder4

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top