Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Protection
Resolved · Low Priority · Version 2003
Mary has attended:
Excel Intermediate course
Project Intermediate course
How do you password protect a workbook?
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
|
Excel tip:Selecting your working rangeIn excel if you have an area you want to highlight, press Ctrl + * or Ctrl+Shift+8 (to get the *). This will select your working range. |
We'll call during UK business hours
Server loaded in 0.08 secs.