Now, open your new spreadsheet, record a macro, and save it-only here, you can literally start the macro recorder and click save without doing anything else as all we need is a blank, placeholder macro. ![]() So, select all the text in the editor, and copy it. All you need to do is copy this script and use it in the other spreadsheet. To do that, first open the spreadsheet with your macro, click Tools → Macros → Manage Macros, then click the menu beside the macro you want to copy, and select Edit Script.Įach macro is powered by a Google Apps Script that you can copy over to use in any other spreadsheet. You’ll need to recreate them on other spreadsheets if you want to use them elsewhere. ![]() There’s only one problem: Google Sheets Macros only work on the spreadsheet where you make them.
0 Comments
Leave a Reply. |