/* * Our main handler * The onEdit trigger is one of three built-in triggers * This function, if defined, is called automatically */ function onEdit(event) { var ss = event.source.getActiveSheet(); var r = event.source.getActiveRange(); r.setComment("Last modified: " + (new Date())); copyPhoneList(); zebraStripe("Read Only"); } // The onOpen function is executed automatically every time a Spreadsheet is opened function onOpen(e) { var ss = SpreadsheetApp.getActiveSpreadsheet(); var menuEntries = []; menuEntries.push({name: "Generate Office Sheets", functionName: "createOfficeSheets"}); ss.addMenu("Internal Tools", menuEntries); protectSheet('Read Only'); createOfficeSheets(); }