Hi Fiona,
Whoop, whoop! You are so clever! I can’t see it run as the tab ‘template’ is protected ;-(
The final (i hope) thing is that I want to protect all but one of the spreadsheets. Not a biggy but if I can have read only for majority of the tabs it would save potential corruption and means that the people who have access to it can only enter data in one place. Prob being is that I really can’t be bothered going in and individually locking all tabs, and it wont do it automatically based on the Template Tab being locked.
There are two Add-ons in the Resource Library which might do this:
- editLock which is a new Add-on which may achieve this for you.
- Bulk Sheet Manager
…what I don’t know is whether you can automate the locking process, but editLock looks promising for this – I suspect it is intended to automatically lock based on a form submission.
Here is the search I did in the Resource Library:
