How To Enable Macros In Google Sheets

In this tutorial, you will learn how to enable macros in Google Sheets.

Unlike certain other spreadsheet programs such as Excel, when you open a Google Sheet that contains macros, you won’t see a banner with the option to enable macros. What’s more, digging through the menus won’t come up with the option either

So how do you enable macros in Google Sheets?

Follow these steps to learn how:

Step 1

Open the Google Sheet that contains macros

Step 2

Open the Tools menu, then hover over Macros and you’ll see a list of existing macros. Click on any of the macros to proceed with enabling all macros. Note that you can also select a macro using the shortcut keys assigned to it (CTRL + ALT + SHIFT + 1 in the image below). This will have the same effect.

Step 3

If you only see the Record, Manage and Import options and no macros listed, the Google Sheet contains no macros. You can record a new macro using the Record option, then return to this step to proceed with enabling the new macro

Step 4

Once you’ve selected a macro from the list, a popup will appear saying authorization is required. If you trust the creator of the macro, click Continue

Step 5

On the next screen, you’ll be prompted to select a Google account to run the macro under. Click on an account or choose Use Another Account and log into the desired account

Step 6

Check the list of permissions the macro is requesting. For a normal macro, it should only be “View and manage spreadsheets that this application has been installed in”. If everything looks ok, click on Allow at the bottom of the screen

Step 7

The authorization popup will close. Macros are now enabled. Run any macro via the Macros menu or associated keyboard shortcuts

Quick Navigation

Summary

Example Spreadsheet: Make a copy of the example spreadsheet

In this tutorial, I covered how to enable macros in Google Sheets. Want more? Check out all the Google Sheets Tutorials.