Breaking News: Grepper is joining You.com. Read the official announcement!

google app script when user uses on edit protected range

Faithful Ferret answered on February 11, 2021 Popularity 1/10 Helpfulness 1/10

answer google app script when user uses on edit protected range

google app script when user uses on edit protected range

Comment

  / Remove all range protections in the spreadsheet that the user has permission to edit.
var ss = SpreadsheetApp.getActive();
var protections = ss.getProtections(SpreadsheetApp.ProtectionType.RANGE);
for (var i = 0; i < protections.length; i++) {
  var protection = protections[i];
  if (protection.canEdit()) {
    protection.remove();
  }
}

Popularity 1/10 Helpfulness 1/10 Language whatever

Source: cloud.google.com

Tags: edit protected range script uses whatever when

Link to this answer
Share Copy Link

Contributed on Feb 11 2021

Faithful Ferret

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

google app script when user uses on edit protected range

Contents

More Related Answers

google app script when user uses on edit protected range

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.