changing password in Excel workbook

V

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

fluffymoore

Hi,

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

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

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!!
 
G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top