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.

1 Answer 1


There isn't a built-in feature to protect or edit the protection of several sheets at once but Google Apps Script could be used to automated this task or an add-on created by yourself or by someone else.



Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.