Forum home » Delegate support and help forum » Microsoft Excel Training and help » Password Protect
|
|
|
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 Protect
Resolved · Low Priority · Version 2007
Reply Sun 12 Sep 2010, 21:36Delegate Rosanne said...
Rosanne has attended:
Excel Intermediate course
Password Protect
Hi,
How do I password protect so that my spreadsheet will ask for the password to be able to edit or give them the option to read only?
thank you,
Rosie
For upcoming training course dates see: Pricing & availability
RE: Password Protect
Hi Rosanne,
Thank you for your question.
There are two possible ways of achieiving this.
Firstly go to Tools, Protection and Protect sheet and assign a password.
Secondly, go to File, Save As and then look for the Tools menu. Select General options and then Password.
You can choose to create a password to open and/or modify or choose for Read Only recommended.
I hope this helps and answers your question.
Regards
Simon
RE: Password Protect
Hi Rosanne
I hope the response received to your question has helped.
If you require further assistance, please do reply to this post, otherwise your question will be marked as resolved within five days.
Kind Regards,
Nafeesa
Microsoft Office Specialist Trainer
Will be marked as resolved in 5 days
Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.
Thu 23 Sep 2010: Automatically marked as resolved.
|