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?
I regret you cannot with 'native' functionality (ie not a script). Support has:
And this warning:
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