Dear all,

I've recently created 4 workbooks that are saved as google sheets. I protected all the columns within these workbooks if they had formulas. However, everytime I made a copy of these workbooks, all the protection is gone and that would make the formulas susceptible to edits, etc.

How do I keep these protected sheets protected, even when someone else makes a copy of my workbooks?

I did a search on the internet and someone posted this https://webapps.stackexchange.com/qu...its-permission, and it looks like scenario #2 may be something that I'm looking for, i.e., I did not lock the entire sheet, only some ranges.

But where do I enter all this code into google sheets in order to see if it even works?

Thank you for any advice you can provide.

Anita