How to protect the same criteria (formulas) across multiple sheets?

Thankyou for attending the course on Tuesday, i hope you really enjoyed it.

The answer to you question is as follows: there are two ways to make your sheets protected so that multiple one are protected i would reconmend you use this one

when you go to file, save as. From the window that comes up go to the top right of the window and choose tools, then click general options, then put in a password to open and a password to modify which should do the trick, you will need to enter (both passwords twice).

This will then prompt other users to input apassword to open and another to modify so if they get in to the file and try to change things they will need to input another password, PS make the 2 p.words different

If this posting has helped in answering your query then I would request you to mark the posting as Resolved. If, however, it hasn’t and you need further clarification then please press the reply button and ask for further clarification with your specific question. In case you have a related question then please ask the question as a separate posting.

Best Regards

Mark East