'How can I lock checkbox once someone ticked in Google sheet

I have added check box in Column AW. How can lock the response (If some one click on the check box) it will be protected/locked?

enter image description here

Please help with the simple way because I am new in Google app script



Solution 1:[1]

Once checked stays checked

function onEdit(e) {
  //e.source.toast('Entry');
  const sh = e.range.getSheet();
  //sh.getRange("A1").setValue(JSON.stringify(e));
  if(sh.getName() == "Sheet0" && e.range.columnStart == 49 && e.range.rowStart > 1 && e.value == "FALSE" ) {
    //e.source.toast('Flag1')
    if(e.oldValue == "true")e.range.setValue("TRUE");
  }
}

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1