Skip to main content

Posts

Showing posts from July, 2020

Create Menu in Google sheet and link to another sheet

Create a Custom Menu to link another sheet In google sheet   Create a custom menu and link to another sheet by using the app script editor. For Custom menu items   use simple trigger function, which is   onOpen()   . To update  onOpen()   and add new menu items in the menu bar do the following.   ·          In the menu bar click on tools - > script editor add following script .   ·          You can add your desired menu item name as per your requirement. ·          Change the Menu name as per your requirement (i.e.; ‘My Data’ ‘Progress-Report’, ‘Sales’. ‘Max’, ‘Rocky’)   function onOpen() {   var ui = SpreadsheetApp.getUi();   ui.createMenu('MyData')       .addItem('Progress-report', 'menu1')       .addSeparator()       .addSubMenu(ui.createMen...