Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function onEdit(e) {
- var sheet = e.source.getActiveSheet();
- var range = e.range;
- if (range.getA1Notation() == "A13") {
- sheet.getRange("C12:I15").setValue("FALSE");
- sheet.getRange("A12:A13").setValue("FALSE");
- } else if (range.getA1Notation() == "A27") {
- sheet.getRange("C26:K29").setValue("FALSE");
- sheet.getRange("A26:A27").setValue("FALSE");
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement