Forum home » Delegate support and help forum » Microsoft Excel Training and help » Password protection for workbook

Password protection for workbook

ResolvedVersion 2010

Mon 31 Oct 2011, 11:23 Delegate Nan said...

Nan has attended:
Excel Intermediate course
Excel Advanced course

Password protection for workbook

Hi,

I have a documents at work, other colleague has put 2 layers of passwords to proect the workbook when you opens up the excel workbook. How do I change the second password on version 2010? or even remove the second password?

Many thanks

Tue 1 Nov 2011, 14:58 Trainer Doug said...

RE: Password protection for workbook

Hi Nam

If you know the passwords then you can change or remove them as follows -

1. Open the file entering the passwords
2. Select File, Save As.
3. Click Tools, General Option at botton left.
4. Change the second level 'Password to modify' or remove the black circles.
5. Click Save.

Hope that helps. More difficult if you don't know the passwords.

Regards
Doug Dunn
Best STL

Tue 8 Nov 2011: Automatically marked as resolved.

Excel tip:

Make a quick copy of a worksheet

Hold down the Ctrl key, then click and drag on a sheet tab to make a copy of that sheet. Though this process usefully copies the formats of the original sheet, note that any Range Names you have on the original sheet will be duplicated too.

To make a copy of a worksheet's contents and formats without duplicating range names: (1) Ensure that you have a blank worksheet to paste to. (2) On the sheet to copy, click on the sheet selection square to the left of Column A's heading to select the whole sheet. (2) Copy the whole sheet. (3) Paste to the blank worksheet.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Password protection for workbook

Password protection for workbook

RE: Password protection for workbook

Excel articles

Excel tip:

Make a quick copy of a worksheet