changing password in Excel workbook

[Val]

I have a workbook (1 spreadsheet) that is password protected. When I try to
open the workbook, I am promted for a password. I enter it and the workbook
opens without any problems.
The problem starts when I try to change the password.
I tried to change the password by going to Tools, Protection, Protect
Workbook. At this point I am promted for a password.
When I try to enter the same password that I used to open the workbook, it
does not recognize it.

 

[fluffymoore]

Hi,

You need to goto, Tools, Options, Security. You should find the password
there that allows you to open the workbook!

 

[Val]

I can open the workbook with the password that I know. When I go to Tools,
Options, Security, I see encrypted password but I can not copy it.
What I am not able to do is to change the password.

 

[fluffymoore]

To Change the password in the security box:

Highlight the encryption and overtype with the password you want it to be
and hit enter; It will then prompt you to retype your password. TADA!!

 

[Val]

Ok. What about the way I was trying to do it? What is that functionality for?

 

[Gord Dibben]

Val

There are several types of protection.

1. Password to open the file. Can be set at File>Save As>Tools>General
Options.

2. Password on a protected worksheet. This is set at Tools>Protection>Protect
Sheet.

Many functions can be disabled using this type of protection.

3. Workbook Protection password. This is set at Tools>Protection>Protect
Workbook.

This protects the workbook from having sheets deleted and other functions
disabled.

4. VBA Project password to prevent viewers from looking at code modules.

NOTE: except for File to Open protection and VBA project passwords, most forms
of Excel protection are very weak and passwords can be easily cracked.


Gord Dibben MS Excel MVP

 

[fluffymoore]

That way is to protect the sheet (tab)!!

Ok. What about the way I was trying to do it? What is that functionality for?