🔒 Closed Google Sheet App Script

[Hatness]

Help naman mga Lods sa mga marunong jan gumawa or gumamit ng Google Sheet App Script.

Situation:

1st Sheet as Main Menu and the other sheets are hidden, Then, 1)may button sa Main Menu pra ma show yung hidden specific sheet. 2) Tapos yung back to Menu button pra ma hide naman yung sheet.

Eto yung mga ginagamit ko ngayon. working naman kso prang nagsasabay yung function. Lalabas lang yung sheet then magco close din agad without clicking sa back to menu button:

function page(sheetName) {
SpreadsheetApp.getActive().getSheetByName('Sheet3').activate();
}

function hideSheet(sheetName) {
SpreadsheetApp.getActive().getSheetByName('Sheet3').hideSheet();
// Hide a sheet named "Sheet3"
hideSheet("Sheet3");
}

Thank mga Lods, sana may makapansin.

 

[Hatness]

Up!

 

[Hatness]

Up lng po.