{"id":254707,"date":"2017-11-29T15:00:28","date_gmt":"2017-11-29T14:00:28","guid":{"rendered":"https:\/\/blog.sheetgo.com\/?p=7434"},"modified":"2026-10-15T16:02:38","modified_gmt":"2026-10-15T14:02:38","slug":"como-nomear-intervalos-ou-celulas","status":"publish","type":"post","link":"https:\/\/www.sheetgo.com\/pt\/blog\/google-sheets-features\/create-macros-in-google-sheets\/","title":{"rendered":"Macros do Google Sheets: como ativar, criar e usar"},"content":{"rendered":"

[et_pb_section fb_built=”1″ admin_label=”section” _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content” da_is_popup=”off” da_exit_intent=”off” da_has_close=”on” da_alt_close=”off” da_dark_close=”off” da_not_modal=”on” da_is_singular=”off” da_with_loader=”off” da_has_shadow=”on” da_disable_devices=”off|off|off”][et_pb_row admin_label=”row” _builder_version=”4.16″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

Google Sheets macros let you record a routine task once, such as formatting a table or tidying up a report, and replay it with a click or a keyboard shortcut. You don’t need to write code to record one, and every macro is saved as Google Apps Script, so you can edit it later.<\/p>\n

This guide explains what macros are, why Google Sheets has no setting to enable them, and how to record, run, edit, and import your own. It ends with two examples you can copy.<\/p>\n

[\/et_pb_text][et_pb_text module_id=”what-are-google-sheets-macros” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

What are Google Sheets macros?<\/h2>\n

Macros are small programs that you can create within Google Sheets. Since you don\u2019t need to use code, it\u2019s become a highly valuable feature to automate repetitive tasks, regardless of the user level. For example, if a regular task in your day-to-day is to format tables following a specific process, you can record this process with the macro recorder (see the last section in this article for more detailed examples).<\/p>\n

There\u2019s an obvious advantage \u2013 apart from saving you tons of manual work \u2013 and it\u2019s that Google Sheets macros can help you focus on higher-value tasks for your business. For example, you can use macros to automate advanced analysis or develop complex formulas. By recording tasks such as filtering or formatting data input, you\u2019ll also be able to deliver more accurate and consistent information.<\/p>\n

The macro recorder is a Google Sheets feature. Google Docs and Google Slides don’t have one, so automating them means writing Apps Script yourself.<\/p>\n

[\/et_pb_text][et_pb_text module_id=”how-to-enable-macros-in-google-sheets” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

How to enable macros in Google Sheets<\/h2>\n

Google Sheets has no setting to enable macros. In Excel, security settings can block macros until you allow them, but in Google Sheets they work by default. The only thing you approve is a one-time authorization: the first time you run a macro, Google asks for permission to let its Apps Script code work with your spreadsheet. Steps 6 to 8 in the next section show those prompts.<\/p>\n

Say a colleague has shared a spreadsheet with a recorded macro that speeds up table formatting. This is how to find and run it.<\/p>\n

1.<\/strong> Open the Google Sheets containing the recorded macro and head over to Extensions > Macros.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-macros-extensions-menu.webp” alt=”Google Sheets macros \u2014 Extensions menu open with Record macro, Import macro, and Manage macros” title_text=”Extensions menu open with Record macro, Import macro, and Manage macros” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

2.<\/strong> You should see a list of macros. To run one, click on it.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/run-google-sheets-macro-recorded-list.webp” alt=”Run a Google Sheets macro \u2014 recorded Sort by Last Name macro in the Macros submenu” title_text=”Recorded Sort by Last Name macro in the Macros submenu” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

Tip:<\/strong> If the macro has a shortcut number, you can also run it by pressing Ctrl + Alt + Shift and that number, for example Ctrl + Alt + Shift + 1. Our Google Sheets keyboard shortcuts guide<\/a> lists many more.<\/p>\n

If you don’t see a list of macros, the spreadsheet has no recorded macros yet. Let\u2019s see how you can record your own macro in a few simple steps.<\/p>\n

[\/et_pb_text][et_pb_text module_id=”how-to-create-macros-in-google-sheets” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

How to create macros in Google Sheets<\/h2>\n

1.<\/strong> Open a new Google Sheet and head over to Extensions > Macros > Record macro.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/create-google-sheets-macros-record-macro.webp” alt=”Create macros in Google Sheets \u2014 Record macro in the Macros submenu of Extensions” title_text=”Record macro in the Macros submenu of Extensions” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

Tip:<\/strong> To create a Google Sheet without going into your Drive, type \u201csheets.new\u201d into your browser. If you are in your Drive, you can press Shift + s.<\/p>\n

2.<\/strong> In the box below, you\u2019ll see two options: \u201cUse absolute references\u201d or \u201cUse relative references\u201d. If you intend to repeat the same calculation across multiple rows or columns, select the \u201cUse relative references\u201d option.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/record-google-sheets-macro-relative-references.webp” alt=”Record a Google Sheets macro \u2014 recording panel with Use relative references selected” title_text=”Recording panel with Use relative references selected” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

Tip:<\/strong> Use absolute references if you want to apply the macro to new sets of data that have the same range location every time you run it. Relative references are more commonly used when you need to apply formulas to cells. Take into account that the macro will apply to the cell where your cursor is at that moment.<\/p>\n

3.<\/strong> The macro recorder will show every action you take. Once you\u2019ve finished your task, click \u201cSave\u201d.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/record-google-sheets-macro-save-recording.webp” alt=”Record a Google Sheets macro \u2014 Save button in the Recording new macro panel” title_text=”Save button in the Recording new macro panel” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

4.<\/strong> In the \u201cSave new macro\u201d dialog box, provide a name. Optionally, you can enter a number from 0-9 to create your own shortcut to run that macro. Click \u201cSave\u201d to finish.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-macros-name-and-shortcut.webp” alt=”Google Sheets macros \u2014 Save new macro dialog with a name and a Ctrl + Alt + Shift + 1 shortcut” title_text=”Save new macro dialog with a name and a Ctrl + Alt + Shift + 1 shortcut” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

5.<\/strong> Head over to Extensions > Macros. To run the macro, click on it.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/run-google-sheets-macro-from-menu.webp” alt=”Run a Google Sheets macro \u2014 Sort by Last Name macro with its shortcut in the Macros submenu” title_text=”Sort by Last Name macro with its shortcut in the Macros submenu” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

6.<\/strong> The first time you run a macro, Google Sheets asks for permission. Click “Continue”.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-macros-authorization-required.webp” alt=”Enable macros in Google Sheets \u2014 Authorization Required dialog with the Continue button” title_text=”Authorization Required dialog with the Continue button” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

7.<\/strong> Select the Google account you\u2019d like to run this macro on.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-macros-choose-account.webp” alt=”Enable macros in Google Sheets \u2014 Choose an account window for the recorded macro” title_text=”Choose an account window for the recorded macro” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

8.<\/strong> Click on \u201cAllow\u201d to confirm that you trust the recorded macro.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-macros-allow-access.webp” alt=”Enable macros in Google Sheets \u2014 Allow button to let the macro view and manage spreadsheets” title_text=”Allow button to let the macro view and manage spreadsheets” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text module_id=”how-to-edit-rename-or-delete-a-macro” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

How to edit, rename, or delete a macro<\/h2>\n

Every macro you record is saved as a function in the spreadsheet’s Apps Script project. To manage your macros, go to Extensions > Macros > Manage macros. There you can rename a macro or change its shortcut number. Click the three-dot menu next to a macro and choose Edit script to open its code in Apps Script, or Remove to delete it from the Macros menu.<\/p>\n

Removing a macro doesn’t delete its code. The function stays in the Apps Script project until you delete it there too.<\/p>\n

[\/et_pb_text][et_pb_text module_id=”how-to-use-macros-in-google-sheets-examp” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

How to use macros in Google Sheets: examples<\/h2>\n

So far, we\u2019ve shown basic examples to illustrate how to enable and create Google Sheets macros. You can also build macros from code with Google Apps Script<\/a>, the Google Sheets equivalent of Visual Basic for Applications (VBA) in Excel. Don\u2019t worry! There are ready-made codes for repeatable tasks, so you still don\u2019t need to learn a single line of code.<\/p>\n

Example 1: sort all your sheets alphabetically<\/h3>\n

If your spreadsheet has many named tabs, this code puts them in alphabetical order. For more ways to handle tabs, see how to work with multiple sheets<\/a>.<\/p>\n

1.<\/strong> Open Google Sheets and go to Extensions > Apps Script.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-macros-apps-script-menu.webp” alt=”Google Sheets macros with Apps Script \u2014 Apps Script in the Extensions menu” title_text=”Apps Script in the Extensions menu” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

2.<\/strong> A new tab will open in your browser. Copy and paste the following code onto a new line:<\/p>\n

\/\/ sort sheets alphabetically\nfunction sortSheets() {\n  var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();\n  var sheets = spreadsheet.getSheets();\n  var sheetNames = [];\n  sheets.forEach(function(sheet, i) {\n    sheetNames.push(sheet.getName());\n  });\n  sheetNames.sort().forEach(function(sheet, i) {\n    spreadsheet.getSheetByName(sheet).activate();\n    spreadsheet.moveActiveSheet(i + 1);\n  });\n}<\/code><\/pre>\n
[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-macros-sort-sheets-code.webp” alt=”Google Sheets macros with Apps Script \u2014 sortSheets function pasted in the editor” title_text=”SortSheets function pasted in the editor” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
3.<\/strong> Don\u2019t forget to save the script by clicking on the disk icon, as shown below.<\/p>\n
[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-macros-save-script.webp” alt=”Google Sheets macros with Apps Script \u2014 Save project icon in the editor toolbar” title_text=”Save project icon in the editor toolbar” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
4.<\/strong> Back in your spreadsheet, go to Extensions > Macros > Import macro to import this function as a macro.<\/p>\n
Tip:<\/strong> If Import macro is greyed out, Google Sheets hasn’t found a function it can import. Functions already in the Macros menu don’t count. Save the script, reload the spreadsheet, and try again.<\/p>\n
[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/import-google-sheets-macro-menu.webp” alt=”Import a Google Sheets macro \u2014 Import macro in the Macros submenu of Extensions” title_text=”Import macro in the Macros submenu of Extensions” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
5.<\/strong> Click on \u201cAdd Function\u201d to add to your list of macros.<\/p>\n
[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/import-google-sheets-macro-add-function.webp” alt=”Import a Google Sheets macro \u2014 Import dialog with sortSheets and Add Function” title_text=”Import dialog with sortSheets and Add Function” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
6.<\/strong> Go to Extensions > Macros and click on the macro you just imported.<\/p>\n
[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-macros-run-imported-macro.webp” alt=”Google Sheets macros example \u2014 imported sortSheets macro in the Macros submenu” title_text=”Imported sortSheets macro in the Macros submenu” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
7.<\/strong> Google Sheets will automatically sort your sheets in alphabetical order, as shown below.<\/p>\n
[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-macros-sorted-sheet-tabs.webp” alt=”Google Sheets macros example \u2014 sheet tabs sorted as Alkai, Brad, Roberts, Smith” title_text=”Sheet tabs sorted as Alkai, Brad, Roberts, Smith” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
That’s it: you’ve turned an Apps Script function into a Google Sheets macro.<\/p>\n
Example 2: reset all filters<\/h3>\n
Filters are commonly used to visualize and interpret your data better and more clearly. However, not everyone in your team might be interested in your filtering and need to remove these every time you share the data. This macro clears them in one go. If teammates need their own view of the same data, filter views<\/a> let each person filter without affecting other users.<\/p>\n
1.<\/strong> Open Google Sheets and go to Extensions > Apps Script.<\/p>\n
2.<\/strong> A new tab will open in your browser. Copy and paste the following code onto a new line:<\/p>\n
\/\/ reset all filters for a data range on current Sheet\nfunction resetFilter() {\n  var sheet = SpreadsheetApp.getActiveSheet();\n  var range = sheet.getDataRange();\n  range.getFilter().remove();\n  range.createFilter();\n}<\/code><\/pre>\n
[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-macros-reset-filter-code.webp” alt=”Google Sheets macros example \u2014 resetFilter function in the Apps Script editor” title_text=”ResetFilter function in the Apps Script editor” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
3.<\/strong> Follow steps 3-6 from the previous example.<\/p>\n
Like before, as soon as you run the macro, Google Sheets will automatically reset any filter you created in a matter of seconds.<\/p>\n
[\/et_pb_text][et_pb_text module_id=”conclusion” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Conclusion<\/h2>\n
While Excel offers powerful features to automate tasks, including Power Automate or Power Query, Google Sheets macros now also provides powerful automation features. On top of this, Google Apps Script<\/a> is the equivalent of VBA in Excel and has unlocked a greater range of tasks that can help you speed up more complex tasks.<\/p>\n
You should now know what Google Sheets macros are, why the only thing to enable is a one-time authorization, and how to record and run your own. You should also feel ready to start using Apps Script to create functions and import them to run as Google Sheets macros.<\/p>\n
A macro works inside one spreadsheet. When the same data has to move between files, Sheetgo, an AI-powered data automation platform, connects your spreadsheets and keeps them up to date on a schedule. For more ways to save time, read our 10 tips and tricks to maximize Google Sheets<\/a>.<\/p>\n
[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"
Google Sheets macros let you record a routine task once, such as formatting a table or tidying up a report, and replay it with a click or a keyboard shortcut. You don’t need to write code to record one, and every macro is saved as Google Apps Script, so you can edit it later.This guide […]<\/p>\n","protected":false},"author":40,"featured_media":254716,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"We most commonly use Google Sheets to store data and share it with others. Among other things it also lets us manipulate and analyze data, resulting in accordingly establishing trends etc. For a regular user, the tasks can get repetitive and time-consuming leading to error-prone. With the help of formulas, we can automate things to a great extent. But with macros (Google App Scripts) we can accomplish much more. In this article, we explain how to create macros in Google Sheets.\n
Why create macros in Google Sheets?<\/h3>\nLet us consider an example. A sales manager looks at a sales data sheet that is auto-populated with the latest raw information every day. Before he begins his work for the day, he needs to generate a report from this raw data in a pre-defined format. This task is accomplished with the exact same manual steps, and therefore it is highly repetitive in nature. Fortunately for him, he can automate the process and execute it in a matter of seconds. While previously he was taking much more to achieve the same output.\n\nWe will use an extremely simple example to show how to create macros in Google Sheets. Because an advanced example is beyond the scope of this article. We recommend you going through this link<\/a> to learn the advanced concepts. The program we are going to write, for the purposes of demonstration in this article, does the following:\n
    \n \t
  • Inserts a value \"Hello world!\" in the cell A1.<\/li>\n \t
  • Changes the font to 'Calibri'.<\/li>\n \t
  • Changes the font size in cell A1 to 14.<\/li>\n \t
  • Fills the cell A1 with yellow color.<\/li>\n<\/ul>\nIn order for us to get there, we need to navigate to Tools > Script editor<\/strong>.\n\nExample<\/strong> \"Create\n\nOn doing that, it will provide us with a workspace where we can write and execute our program in a separate tab. On the Script editor<\/strong> window, we write the code as shown in the snapshot below. Before we click on the Run<\/strong> button, we may want to Save<\/strong> it using the floppy disk icon.\n\nExample<\/strong> \"Create\n\nWhen we try to execute this program, it might ask us to authenticate for the very first time. Here's the result after the program finished its execution.\n\nExample<\/strong> \"\"\n
    Conclusion<\/h4>\nThat was a fairly simple example that explains how to create macros in Google Sheets. However, the real-time applications can get very complex that usually simplifies a lot of stuff, which otherwise would have been difficult to achieve.\n
    Advantages<\/h4>\nThe Google Apps script is very similar to Office VBA. But in comparison, Google Apps script offers much more benefits than the traditional VBA does.\n
      \n \t
    1. VBA runs on a client machine. Whereas Google script runs on the cloud taking its reach and scale are much higher and more flexible. One can even build web-based applications using the Google script. But we can't achieve that with VBA, that at the most can integrate with web applications using an API.<\/li>\n \t
    2. We can build user interfaces using both VBA and Google script. The former is constrained when it comes to design (we can only build user forms). But with the latter, we can also leverage the technologies such as HTML, CSS, and Javascript.<\/li>\n \t
    3. The list of data types in VBA is limited, as it is still relying on a relatively older technology. While Google script is based on Javascript, which is one of the core web technologies. Therefore we can bank upon its object-oriented elements, flexible data structures, and numerous utilities and build upon that.<\/li>\n<\/ol>","_et_gb_content_width":"","footnotes":""},"categories":[37],"tags":[39,28],"class_list":["post-254707","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-sheets-features","tag-connections-t","tag-spreadsheets"],"acf":[],"permalink_manager":null,"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/254707","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/users\/40"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/comments?post=254707"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/254707\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media\/254716"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media?parent=254707"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/categories?post=254707"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/tags?post=254707"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}