Skip to content

Instantly share code, notes, and snippets.

@chipoglesby

chipoglesby/custommenu.gs

Last active May 24, 2018 13:36
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save chipoglesby/796ae3959820f9b843bb to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save chipoglesby/796ae3959820f9b843bb to your computer and use it in GitHub Desktop.
Download ZIP
Custom File Menu for Google Apps Script
Raw
custommenu.gs
function onOpen() {
var array = [];
ss = SpreadsheetApp.getActiveSpreadsheet();
for (var n in ss.getSheets()) {
var sheets = ss.getSheets()[n];
array.push(sheets.getName());
}
var ui = SpreadsheetApp.getUi();
ui.createMenu('Trip Menu')
.addItem('Trips', 'menuItem1')
.addItem(array, 'menuItem2')
.addToUi();
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment