DISCOVER
×
Loading ...

How to Run Multiple Macros at the Same Time in Excel

Updated July 20, 2017

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.

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

  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. 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. 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.

Loading ...

About the Author

Joshua Laud started writing professionally in 2008. During his three years at University he worked freelance for various music publications including "Clash Magazine" and "total:spec," and online Data Transmission and Music is Art. Laud also specializes in technology writing. He has a Bachelor of Arts in English literature from the University of London.

Loading ...