Protect ranges with google apps script
Solution 1:
Yes, you can accomplish this using the Protection
class. You would first protect the whole sheet using var protection = sheet.protect()
, then unprotect the ranges you want people to be able to edit using protection.setUnprotectedRanges([ranges])
, where [ranges]
is an array of range objects. You can read more about it in the Google Apps Script Class Protection documentation.