Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
What is the best way to protect a document (the objects in it mainly) from being amended by the user? I have a document with several sheets and I want to lock down all the charts etc so that the user can use the document (and possibly export data) but not move, change or add objects in anyway. I know there are sheet properties but it seems a lot of work to have to go through each sheet and set disable everything.
I don't want to add user security in the script it just needs to be protection across all users.
Apologies if the answer to this can be found elsewhere already but I couldn't find anything in the forums or documentation.
Check out Settings -> Document Properties -> Security Tab.