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
Bookmarks