Jeremy has attended:
Excel Intermediate course
Sheet protection
How to protect the same criteria (formulas) across multiple sheets?
RE: Sheet protection
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