How to Run Multiple Macros at the Same Time in Excel

Written by joshua laud
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Run Multiple Macros at the Same Time in Excel
(Jupiterimages/Polka Dot/Getty Images)

If you have created an Excel worksheet that uses a lot of macros, then you may wish to run multiple macros at the same time. Macros save time by automating tasks and performing them automatically at the click of a button. In Excel, you can use a certain macro function to run multiple macros at the same time. This is the "call" function. Using call, you can create a master macro that will run all of your other required macros.

Skill level:

Other People Are Reading


  1. 1

    Click "Start" > "All Programs" > "Microsoft Excel." Click "File" > "Open," then locate and open the Excel worksheet that contains multiple macros.

  2. 2

    Click "Tools" > "Macro" > "Record New Macro." Enter a name such as "master" and click "OK." Click the "Stop" button right away. Click "Tools" > "Macro" > "Macros." Click "Master" > "Edit." This launches the Visual Basic Editor.

  3. 3

    Type "Call Macro1" inside the "Sub" and "End Sub" commands, then press "Enter." Type "Call Macro2," then press Enter." Repeat this for all the macros that you want to run simultaneously. Replace "Macro1" and "Macro2" with the names of the macros that you wish to run at the same time.

  4. 4

    Close the Visual Basic Editor. It will ask whether you want to save your macro. Click "Yes." When you run the "master" macro, it will now run all other macros specified in Visual Basic.

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.