Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Protection of Workbook

Resolved · High Priority · Version 2010

Reply Thu 20 Oct 2011, 15:49Delegate Kim said...

Kim has attended:
Excel Intermediate course

Protection of Workbook

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

For upcoming training course dates see: Pricing & availability

Reply Fri 21 Oct 2011, 10:11Trainer Simon said...

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 articles

· How To Learn From Your Excel Mistakes
· A Beginners Guide To Formulas In Excel
· Differences In Excel 2003, 2007 And 2010
· Become A Budding Picasso Using Excel
· Customize Your Gridlines And Borders In Excel 2007

Please browse our web site to find out more about
excel course in london and other Microsoft training courses.

Excel tip:

Reset Excel toolbars to default settings

If you find any of your toolbars in Excel have changed (i.e. they are missing or have extra buttons) then you can reset them to their defaults.

1. Go to Tools - Customise.
2. Select the Toolbars tab.
3. Select (highlight) the name of the toolbar you wish to reset, then click the Reset button on the right.
4. Close the dialogue box.

View all Excel hints and tips