11
votes
Accepted
Can I protect the formatting of a Google Sheets?
The way to address the problem is to use a combination of custom function in google spreadsheet and google script. I will use examples to try to address solution for your problem
Formula protection :
...
- 501
1
vote
Remove All Protections on Selected Range
You want to delete all the protections, so you must be looking for a process that repeat itself, as long as the condition is matched. In your case as long there is a protection on C4:F30.
Intuitively:
...
- 181
Only top scored, non community-wiki answers of a minimum length are eligible