google-apps-script Spreadsheet Add Menu
Syntax
- addMenu(name, subMenus)
Parameters
| Name | Description |
|---|---|
| name | the name of the menu to be created |
| subMenus | an array of JavaScript maps |
Remarks
Usually, you will want to call addMenu from the onOpen function so that the menu is automatically created when the Spreadsheet is loaded.
// The onOpen function is executed automatically every time a Spreadsheet is loaded
function onOpen() {
var activeSheet = SpreadsheetApp.getActiveSpreadsheet();
var menuItems = [];
// When the user clicks on "addMenuExample" then "Menu 1", the function Myfunction1 is executed.
menuItems.push({name: "Menu 1", functionName: "Myfunction1"});
menuItems.push(null); // adding line separator
menuItems.push({name: "Menu 2", functionName: "Myfunction2"});
activeSheet.addMenu("addMenuExample", menuEntries);
}
