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 » Excel 2007
Excel 2007
Resolved · High Priority · Version 2007
Marc has attended:
Excel Intermediate course
Excel Advanced course
Excel 2007
How do you protect a workbook so that when re-opened, one has to enter a password before ANY information is seen?
RE: Excel 2007 - Pasword Protecting your Workbooks
Dear Marc
Thank you for attending Excel 2007 Intermediate course.
I hope you enjoyed the course and benefited from it.
To password protect your Excel file in 2007 you have to go to your save As dialog box.
In the save As Dialog box you'll notice there will be Tools Button either on the bottom left hand coner or Top Right hand corner.
Please click on the drop down arrow and choose General options. Type the password you wish to set for the file. You can set different passwords; one for opening and one for modifying the file. You will be asked to re-enter the password.
IT IS VERY IMPORTANT THAT YOU REMEMEBR YOUR PASSWORD OTHERWISE IT CAN BECOME VERY VERYT DIFFICULT TO OPEN YOUR OWN FILES!!
I hope this helps!!
Please mark this post as resolved if it has helped you in answering the question!!
Many thanks
Kindest Regards
Rajeev Rawat
MOS Master Instructor 2000/2003
MCAS Master Instructor 2007
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:Entering text in Multiple WorksheetsIf you have a number of worksheets in a workbook that require the same information (data or tables) on each worksheet, this can be done as follows: |