changing password in Excel workbook
 

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.

--
Val

changing password in Excel workbook
 

Hi,

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

"Val" wrote:

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.

--
Val

changing password in Excel workbook
 

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.
--
Val


"fluffymoore" wrote:

Hi,

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

"Val" wrote:

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.

--
Val

changing password in Excel workbook
 

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" wrote:

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.
--
Val


"fluffymoore" wrote:

Hi,

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

"Val" wrote:

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.

--
Val

changing password in Excel workbook
 

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


"fluffymoore" wrote:

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" wrote:

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.
--
Val


"fluffymoore" wrote:

Hi,

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

"Val" wrote:

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.

--
Val

changing password in Excel workbook
 

Val

There are several types of protection.

1. Password to open the file. Can be set at FileSave AsToolsGeneral
Options.

2. Password on a protected worksheet. This is set at ToolsProtectionProtect
Sheet.

Many functions can be disabled using this type of protection.

3. Workbook Protection password. This is set at ToolsProtectionProtect
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

On Sat, 11 Nov 2006 09:02:01 -0800, Val wrote:

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

changing password in Excel workbook
 

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

"Val" wrote:

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


"fluffymoore" wrote:

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" wrote:

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.
--
Val


"fluffymoore" wrote:

Hi,

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

"Val" wrote:

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.

--
Val