98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Sheet protection
Sheet protection
Resolved · Low Priority · Version Standard
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
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Editing a formula quicklyIf you want to edit a fomrula or text quickly witin a cell instead of the formula bar, you can click either double click in the cell or press the F2 key |