Skip to main content

Hey everyone,


im kinda new in google sheets and google apps script. First i got a code where a sheet is hidden, if the checkbox in a specific cell is checked.


function onEdit(a) {

  var range = a.range;

  if (range.getA1Notation() == "B13") {

    var Agenda = a.source.getSheetByName("Agenda");

    if (range.isChecked()) {

      Agenda.showSheet();

    } else {

      Agenda.hideSheet();

    }

  }

}

Now i got the problem that i have multiple sheets. But this code shall only work in one of the sheets.


So i tried two different things:


if (activeSheet.getName() !== "Allgemeine Informationen") return;


and


if (activeSheet.getName() == "Allgemeine Informationen") {

...

}

Both doesn’t work properly.


I also tried to get the value of the function by writing the value of “activeSheet.getName()” in a cell but the cell kept empty.


So Long Text Short Question: How can i put an if function that makes the code only executing when the active sheet has the name “Allgemeine Informationen”?


Friendly Regards

Solved it by using a different code. 🙂

Reply


Terms & Conditions