Script to Unprotect All Protected Ranges
I wrote an Apps Script file to protect cells on-edit, and it was working for a while, but it stopped working recently. I suspect I hit some sort of cap on the number of protected ranges one sheet can have. I’d rather not delete thousands of protected ranges manually, so I’m trying to write a script that will remove all protections automatically when run.