How to run the same macro on multiple worksheets at same time in Excel?

Normally, we can run a macro in a worksheet, if there are multiple sheets need to apply this same macro, you should trigger the code one by one sheet. If there any other quick way to run the same macro on multiple worksheets at once in Excel?

Run or execute the same macro on multiple worksheets at same time with VBA code

Run or execute the same macro on multiple worksheets at same time with VBA code

To run a macro on multiple sheets at 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 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.