Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

I have created my spreadsheet with protected cells scattered throughout the document in google docs. Now I want to duplicate the spreadsheet and have the protected cells in the new worksheet keep the same protection. The new spreadsheet would be in the same workbook (tabs). I have tried copy and paste into the new worksheet and all copies but the protection. How would I accomplish this task?

share|improve this question

1 Answer 1

I regret you cannot with 'native' functionality (ie not a script). Support has:

If an editor duplicates the protected sheet, copies the workbook, or uploads a new version, sheet protection will be disabled. Also, if a viewer creates a copy of the spreadsheet, the data on the protected sheet can be edited in the copy.

And this warning:

Protected sheets and ranges can help prevent people from unintentionally modifying content in a spreadsheet, but they should not be used for security purposes because not all actions are blocked (for example, printing, copying and pasting, and importing and exporting). Only share spreadsheets with people you trust.

Protected ranges are sheet specific. You may have noticed that when protecting ranges, even if only supplying range references, the relevant sheet name is prepended to these automatically. You might sacrifice those in your 'existing' sheet (say S1) for the sake of your copied sheet (say S2) by manually changing all the S1! to S2! in the Protected sheets and ranges window.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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