Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
protection workbook

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Protection of Workbook

Protection of Workbook

ResolvedVersion 2010

Kim has attended:
Excel Intermediate course

Protection of Workbook

How can you unprotect an entire workbook rather than sheet by sheet?

RE: Protection of Workbook

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:

Charts

Select the data and press the function key F11 and the chart will be created on a separate worksheet.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.