Forum home » Delegate support and help forum » Microsoft Excel Training and help » Password protection for workbook
|
|
|
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. |
Password protection for workbook
Resolved · High Priority · Version 2010
Reply Mon 31 Oct 2011, 11:23Delegate Nan said...
Nan has attended:
Excel Intermediate course
Excel Advanced course
Password protection for workbook
Hi,
I have a documents at work, other colleague has put 2 layers of passwords to proect the workbook when you opens up the excel workbook. How do I change the second password on version 2010? or even remove the second password?
Many thanks
For upcoming training course dates see: Pricing & availability
RE: Password protection for workbook
Hi Nam
If you know the passwords then you can change or remove them as follows -
1. Open the file entering the passwords
2. Select File, Save As.
3. Click Tools, General Option at botton left.
4. Change the second level 'Password to modify' or remove the black circles.
5. Click Save.
Hope that helps. More difficult if you don't know the passwords.
Regards
Doug Dunn
Best STL
Tue 8 Nov 2011: Automatically marked as resolved.
|