How do add editors but to only the unprotected cells

Question

I have about 70 tabs that I am setting protection up for other than certain ranges which I want to be editable by all, however, if I protect them all, then share the workbook, everyone becomes an editor and can then edit the protected ranges. Any thoughts?

  spreadsheet.setActiveSheet(spreadsheet.getSheetByName('A330'), true);
  protection = spreadsheet.getActiveSheet().protect();
  protection.setUnprotectedRanges([spreadsheet.getRange('O13:O18'), 
  spreadsheet.getRange('O24:O29'), spreadsheet.getRange('O35:O45')])

  spreadsheet.setActiveSheet(spreadsheet.getSheetByName('A340'), true);
  protection = spreadsheet.getActiveSheet().protect();
  protection.setUnprotectedRanges([spreadsheet.getRange('O13:O18'), 
  spreadsheet.getRange('O24:O29'), spreadsheet.getRange('O35:O45')])

GoranK GoranK · Accepted Answer · 2019-05-29T09:26:29

you need to protect the unprotected ranges (SpreadsheetApp.ProtectionType.RANGE) and give access only to certain users.

How do add editors but to only the unprotected cells

1 Answers