How to run the same macro on multiple worksheets at once in Excel?
In Excel, you can run a macro on a single worksheet, but what if you need to apply the same macro across multiple sheets at once? Instead of triggering the macro individually for each sheet, you can execute it on all selected worksheets simultaneously. In this guide, we’ll show you how to use VBA to run the same macro across multiple worksheets in a more efficient way, saving you time and effort.
Run or execute the same macro on multiple worksheets at the same time with VBA code
Run or execute the same macro on multiple worksheets at the same time with VBA code
To run a macro on multiple sheets at the same time without triggering it one by one sheet, you can apply the following VBA code, please do as this:
1. Hold down the ALT + F11 keys to open the Microsoft Visual Basic for Applications window.
2. Click Insert > Module, and paste the following macro in the Module Window.
VBA code: Run the same macro on multiple worksheets at the same time:
Sub Dosomething()
Dim xSh As Worksheet
Application.ScreenUpdating = False
For Each xSh In Worksheets
xSh.Select
Call RunCode
Next
Application.ScreenUpdating = True
End Sub
Sub RunCode()
'your code here
End Sub
Note: In the above code, please copy and paste your own code without the Sub heading and End Sub footer between the Sub Runcode() and End Sub scripts. See screenshot:
3. Then put the cursor at the first part macro, and press F5 key to run the code, and your macro code will be applied to one by one sheet.
Easily Remove Macros from Multiple Workbooks |
Kutools for Excel's Batch Remove All Macros tool allows you to quickly remove macros from multiple workbooks at once. |
 |
Kutools for Excel - Supercharge Excel with over 300 essential tools. Enjoy permanently free AI features! Get It Now |
Best Office Productivity Tools
Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time. Click Here to Get The Feature You Need The Most...
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
- Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
All Kutools add-ins. One installer
Kutools for Office suite bundles add-ins for Excel, Word, Outlook & PowerPoint plus Office Tab Pro, which is ideal for teams working across Office apps.
- All-in-one suite — Excel, Word, Outlook & PowerPoint add-ins + Office Tab Pro
- One installer, one license — set up in minutes (MSI-ready)
- Works better together — streamlined productivity across Office apps
- 30-day full-featured trial — no registration, no credit card
- Best value — save vs buying individual add-in