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 » Password Protect
Password Protect
Resolved · Low Priority · Version 2007
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
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.
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:Use shortcut keys to select rows or columnsMost users use the mouse to select rows or columns. It may be more convenient to use keyboard shortcuts to do that. |