Forum home » Delegate support and help forum » Microsoft Excel Training and help » Protection
|
|
|
The UK's most regular 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. |
Protection
Resolved · Low Priority · Version 2003
Reply Tue 20 May 2008, 16:35Delegate Mary said...
Mary has attended:
Excel Intermediate course
Project Intermediate course
Protection
How do you password protect a workbook?
For upcoming training course dates see: Pricing & availability
RE: Protection
Hi Mary,
Thank you for your question.
In order to protect a workbook, please follow these instructions:
1. File - Save AS.
2. Name the file and choose the location to save it in.
3. Then click on the Tools menu.
4. Select General options.
5. You can now enter two passwords if you want, one to open the workbook ad the second to modify it.
6. Then save the document.
To remove a password, once the file is opened, follow instructions 1,2,3,4 and highlight the stars in the password field and delete them so the boxes are blank. Then save the document.
I hope this answers your question.
Regards
Simon
|