Tetap teratur dengan koleksi
Simpan dan kategorikan konten berdasarkan preferensi Anda.
Konfigurasi yang digunakan untuk menentukan
Makro Spreadsheet. Manifest yang menentukan makro harus memiliki semua kolom yang ditandai sebagai Wajib diisi.
Spreadsheet
Tingkat teratas konfigurasi manifes makro Spreadsheet. Fungsi ini hanya
digunakan untuk menentukan makro Spreadsheet.
Menentukan pintasan keyboard yang menjalankan makro.
Harus dalam bentuk Ctrl+Alt+Shift+Number,
dengan Number adalah satu digit. Makro tanpa
pintasan hanya dapat dijalankan dari menu Alat > Makro.
functionName
string
Wajib. Nama fungsi Apps Script yang menjalankan
makro. Secara default, ini cocok dengan menuName untuk
fungsi yang dibuat secara otomatis, tetapi ini bukan persyaratan.
menuName
string
Wajib. Nama makro seperti yang muncul di
UI Google Spreadsheet.
[null,null,["Terakhir diperbarui pada 2025-08-31 UTC."],[[["\u003cp\u003eSheets macros are defined using a manifest configuration, which must include all required fields.\u003c/p\u003e\n"],["\u003cp\u003eEach macro definition specifies a keyboard shortcut, the name of the Apps Script function to execute, and the menu name displayed in the Google Sheets UI.\u003c/p\u003e\n"],["\u003cp\u003eThe keyboard shortcut must be unique and follow the format \u003ccode\u003eCtrl+Alt+Shift+\u003c/code\u003e followed by a single digit.\u003c/p\u003e\n"],["\u003cp\u003eMacros without assigned shortcuts can only be run from the \u003cstrong\u003eTools > Macros\u003c/strong\u003e menu in Google Sheets.\u003c/p\u003e\n"]]],[],null,["# Sheets macro manifest resource\n\nThe configuration that is used to define\n[Sheets macros](/apps-script/guides/sheets/macros#manifest_structure_for_macros). Manifests that define macros must have all the fields\nmarked as **Required**.\n\nSheets\n------\n\nThe top-level of the Sheets macro manifest configuration. This is only\nused to define Sheets macros.\n\n| JSON representation |\n|--------------------------------------------------|\n| ```text { \"macros\": [ { object (Macro) } ] } ``` |\n\n| Fields ||\n|------------|------------------------------------------------------------------------------------------------------|\n| `macros[]` | `object (`[Macro](#macro)`)` **Required.** A list of defined macros and their associated properties. |\n\n### Macro\n\nThe configuration for a single macro. The definition must have all the fields\nmarked as **Required**.\n\n| JSON representation |\n|---------------------------------------------------------------------------------------|\n| ```text { \"defaultShortcut\": string, \"functionName\": string, \"menuName\": string } ``` |\n\n| Fields ||\n|-------------------|----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|\n| `defaultShortcut` | `string` Defines the keyboard shortcut that executes the macro. This **must** be of the form `Ctrl+Alt+Shift+`*Number*, where *Number* is a single-digit. Macros without shortcuts can only be executed from the **Tools \\\u003e Macros** menu. | **Warning**: the keyboard shortcut used by each defined macro must be unique. |\n| `functionName` | `string` **Required.** The name of the Apps Script function that executes the macro. By default this matches the `menuName` for functions automatically created, but this is not a requirement. |\n| `menuName` | `string` **Required.** The name of the macro as it appears in the Google Sheets UI. |"]]
