Guest User

Untitled

a guest
Dec 10th, 2018
86
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.28 KB | None | 0 0
  1. //8. hide all sheets except the active one
  2. function hideAllSheetsExceptActive() {
  3. var sheets = SpreadsheetApp.getActiveSpreadsheet().getSheets();
  4. sheets.forEach(function(sheet) {
  5. if (sheet.getName() != SpreadsheetApp.getActiveSheet().getName())
  6. sheet.hideSheet();
  7. });
  8. };
Add Comment
Please, Sign In to add comment