Skip to main content

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

Required fields*

4
  • Decided to change my previous comment: How can You prevent user A to enter values to range A1:B2 and then prevent user B to enter values in B2:C3? I've not found this functionality anywhere. Commented Nov 24, 2020 at 11:49
  • Just like done in the solution you linked: protection1.removeEditors(protection1.getEditors()); protection1.addEditor('[email protected]'); and protection2.removeEditors(protection2.getEditors()); protection2.addEditor('[email protected]'); Commented Nov 24, 2020 at 12:21
  • 1
    I'm really surprised it works, I've been trying to play with that for few hours and the user always had option to edit. But I understood principle and it makes sense/works. Thanks! Commented Nov 24, 2020 at 17:39
  • 1
    Btw. I became now aware of the fact that you can use the method setUnprotectedRanges(ranges). I believe that this should useful to you. Commented Nov 26, 2020 at 8:47