Advertisement
Guest User

Untitled

a guest
Jul 18th, 2019
69
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.78 KB | None | 0 0
  1. function hideRows5to60() {
  2. var spreadsheet = SpreadsheetApp.getActive();
  3. spreadsheet.getRange('5:60').activate();
  4. spreadsheet.getActiveSheet().hideRows(spreadsheet.getActiveRange().getRow(), spreadsheet.getActiveRange().getNumRows());
  5. spreadsheet.getRange('61:61').activate();
  6. };
  7.  
  8. function showRows5to60() {
  9. var spreadsheet = SpreadsheetApp.getActive();
  10. spreadsheet.getRange('4:61').activate();
  11. spreadsheet.setCurrentCell(spreadsheet.getRange('A61'));
  12. spreadsheet.getActiveSheet().showRows(3, 58);
  13. };
  14.  
  15. function onEdit() {
  16. var ss = SpreadsheetApp.getActiveSpreadsheet();
  17. var s = ss.getSheetByName('Duct Leakage');
  18. var cellSh = s.getRange('A4').getValues();
  19. }
  20. if (cellSh = 'unhide');
  21. {
  22. showRows5to60();
  23. }
  24. if (cellSh = 'hide');
  25. {
  26. hideRows5to60();
  27. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement