Advertisement
ShaggyZE1

Untitled

Nov 13th, 2024
37
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.38 KB | None | 0 0
  1. function onEdit(e) {
  2. var sheet = e.source.getActiveSheet();
  3. var range = e.range;
  4.  
  5. if (range.getA1Notation() == "A13") {
  6. sheet.getRange("C12:I15").setValue("FALSE");
  7. sheet.getRange("A12:A13").setValue("FALSE");
  8. } else if (range.getA1Notation() == "A27") {
  9. sheet.getRange("C26:K29").setValue("FALSE");
  10. sheet.getRange("A26:A27").setValue("FALSE");
  11. }
  12. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement