Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- //8. hide all sheets except the active one
- function hideAllSheetsExceptActive() {
- var sheets = SpreadsheetApp.getActiveSpreadsheet().getSheets();
- sheets.forEach(function(sheet) {
- if (sheet.getName() != SpreadsheetApp.getActiveSheet().getName())
- sheet.hideSheet();
- });
- };
Add Comment
Please, Sign In to add comment