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:
Open the Google Sheet that contains macros
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.
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
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
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
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
The authorization popup will close. Macros are now enabled. Run any macro via the Macros menu or associated keyboard shortcuts
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.