Protect

Gists

This is the method for protecting cells of Spreadsheet that users copied from your Google Drive to user’s Google Drive using Google Apps Script.

Situation:

This method supposes the following situation.

• You want to make users copy a Spreadsheet on your Google Drive to user’s Google Drive. - Your Spreadsheet has several protected ranges. - Your Spreadsheet is shared with the user. - User doesn’t have own folder shared with you.
• You want to protect the ranges of Spreadsheet for the user. Namely, you want to remove the user from the editor of protected ranges.
• You want to achieve this using Google Apps Script.

Issue:

In above situation, I think that the following points are the bottleneck.