Ive got a Google Spreadsheet with 50+ data tabs, and 5 Summary tabs at the end.
The 50+ data tabs all have the same column headers.
I want to apply protection to the all these data "data tabs" to stop some people who have edit rights on the spreadsheet from editing the data. Eg. "John" who has edit rights on the spreadsheet would not be able to edit the data in the data tabs, column A:Z, except column E.
In the past Ive done this manually by applying protection to each tab, but its really fiddly, its also really fiddly when i need to edit the protection rules, is there a more automated way i could manage this ?
Perhaps by setting the protection rules as a template then applying that template to the tabs i need.