Skip to content

Instantly share code, notes, and snippets.

@ndthanh
Created December 10, 2018 18:41
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ndthanh/4df4321b2bdcdf3443a8f4aa4f10fb1b to your computer and use it in GitHub Desktop.
Save ndthanh/4df4321b2bdcdf3443a8f4aa4f10fb1b to your computer and use it in GitHub Desktop.
function onOpen( ){
// This line calls the SpreadsheetApp and gets its UI
// Or DocumentApp or FormApp.
var ui = SpreadsheetApp.getUi();
//These lines create the menu items and
// tie them to functions we will write in Apps Script
ui.createMenu('Học Excel Online')
.addItem('1. formulasToValuesActiveSheet', 'formulasToValuesActiveSheet')
.addItem('2. formulasToValuesGlobal', 'formulasToValuesGlobal')
.addItem('3. sortSheets', 'sortSheets')
.addItem('4. unhideRowsColumnsActiveSheet', 'unhideRowsColumnsActiveSheet')
.addItem('5. unhideRowsColumnsGlobal', 'unhideRowsColumnsGlobal')
.addItem('6. setTabColor', 'setTabColor')
.addItem('7. resetTabColor', 'resetTabColor')
.addItem('8. hideAllSheetsExceptActive', 'hideAllSheetsExceptActive')
.addItem('9. unhideAllSheets', 'unhideAllSheets')
.addItem('10. resetFilter', 'resetFilter')
.addSeparator()
.addSubMenu(ui.createMenu('Các khóa học')
.addItem('Google Sheets cho người mới bắt đầu', 'course01')
.addItem('Google Sheets cho người đi làm', 'course02'))
.addToUi();
}
function course01() {
Browser.msgBox("Chào mừng đến với khóa học");
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment