Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function hideRows5to60() {
- var spreadsheet = SpreadsheetApp.getActive();
- spreadsheet.getRange('5:60').activate();
- spreadsheet.getActiveSheet().hideRows(spreadsheet.getActiveRange().getRow(), spreadsheet.getActiveRange().getNumRows());
- spreadsheet.getRange('61:61').activate();
- };
- function showRows5to60() {
- var spreadsheet = SpreadsheetApp.getActive();
- spreadsheet.getRange('4:61').activate();
- spreadsheet.setCurrentCell(spreadsheet.getRange('A61'));
- spreadsheet.getActiveSheet().showRows(3, 58);
- };
- function onEdit() {
- var ss = SpreadsheetApp.getActiveSpreadsheet();
- var s = ss.getSheetByName('Duct Leakage');
- var cellSh = s.getRange('A4').getValues();
- }
- if (cellSh = 'unhide');
- {
- showRows5to60();
- }
- if (cellSh = 'hide');
- {
- hideRows5to60();
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement