I have a Google Sheet that has protected cells that I need to "duplicate" for each week of the month. However, I can't get the protected cells to "carry over" with the new sheet and stay protected. I have to redo them every time.
How can I get the master sheet to stay intact with protected cells?


1 Answer 1


Use Sheet.copyTo(), Sheet.getProtections(), Sheet.protect(), Protection.removeEditors(), Protection.addEditors() and so on to copy protections from the original sheet to the new sheet.

See the copySheetWithProtections_ script for sample code.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.