Solutions Through Learning
Callback
Sign in
Basket
Call us on 0207 987 3777 or Search our website
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Protection of Workbook
Resolved · High Priority · Version 2010
Kim has attended:
Excel Intermediate course
How can you unprotect an entire workbook rather than sheet by sheet?
Hi Kim,
Thank you for your question.
Did you mean Protect a workbook?
Save the file using Save As command. In the Save As dialogue box, go to Tools and then General Options. Create a password, confirm it and then save the file.
The next time you open the file it will prompt you for the password.
I hope this answers your question. If it does, can you please mark it as complete.
Regards
Simon
Thu 27 Oct 2011: Automatically marked as resolved.
|
|
Excel tip:Concatenating Results of FormulasTo concatenate the results of formulas simply add the "&" after the formula or function closing bracket. |
TrustScore
4.9
/ 5
2224 reviews
Connect with us:
We will call you back
Call for assistance
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
We'll call during UK business hours
Server loaded in 0.08 secs.
