change Excel password

C

chequer

Recently I decided to protect my Excel files pertaining to banking and
finance.
After a couple of days I found that I was inconvenienced by having too long
a password, so I decided to use a shorter password

I went to the ‘MS Change Protection’ Help but couldn’t apply it.

What are the simple steps to change my password?
 
D

Dave Peterson

Excel has lots of passwords.

One for the sheet, one for the workbook (to stop
inserting/deleting/renaming/moving sheets), another one to open the workbook,
another one to allow write access and even one that can be used to protect the
workbook's project (VBA code).

I'm guessing that you want to change the password that you see when you try to
open the workbook.

Open your workbook.
File|SaveAs (in xl2003 menus)
Tools|General Options
And specify the password to open (delete the existing and add the new version).
 
C

chequer

Thanks, Dave,
It is a single worksheet.
Where you said, (delete the existing and add the new version), I take it
that this means, (delete the existing PASSWORDand add the new PASSWORD).
While waiting for a reply I unprotected the work sheet, copied it to a new
worksheet then deleted the sheet that I had removed the protection from.
When I had done this I didn't bother to protect the newly created worksheet
as I have a password to open my computered.
Wouldn't this give all my files protection?.

--
chequer
When the game is over, the King and the pawn share the same box.


Dave Peterson said:
Excel has lots of passwords.

One for the sheet, one for the workbook (to stop
inserting/deleting/renaming/moving sheets), another one to open the workbook,
another one to allow write access and even one that can be used to protect the
workbook's project (VBA code).

I'm guessing that you want to change the password that you see when you try to
open the workbook.

Open your workbook.
File|SaveAs (in xl2003 menus)
Tools|General Options
And specify the password to open (delete the existing and add the new version).
 
D

Dave Peterson

I'm confused about your terminology.

A worksheet is a sheet/tab in a workbook.

A workbook is the same thing as a file.

So if you unprotected a worksheet within the workbook, then only that worksheet
would be changed. The other worksheets within this workbook (or any other
workbook) would not be changed.

If you created a new workbook without a password, then only this workbook would
be affected. Any existing workbook didn't change because of what you did. Any
new workbook wasn't affected by what you did.

(And yes, I meant delete the existing password and add the new password.)
Thanks, Dave,
It is a single worksheet.
Where you said, (delete the existing and add the new version), I take it
that this means, (delete the existing PASSWORDand add the new PASSWORD).
While waiting for a reply I unprotected the work sheet, copied it to a new
worksheet then deleted the sheet that I had removed the protection from.
When I had done this I didn't bother to protect the newly created worksheet
as I have a password to open my computered.
Wouldn't this give all my files protection?.
 
C

chequer

Terminology?. Not too sure about it myself.
I'm talking about a single sheet , [Sheet1] with 4 pages.
Thanks for the other info.
--
chequer
When the game is over, the King and the pawn share the same box.


Dave Peterson said:
I'm confused about your terminology.

A worksheet is a sheet/tab in a workbook.

A workbook is the same thing as a file.

So if you unprotected a worksheet within the workbook, then only that worksheet
would be changed. The other worksheets within this workbook (or any other
workbook) would not be changed.

If you created a new workbook without a password, then only this workbook would
be affected. Any existing workbook didn't change because of what you did. Any
new workbook wasn't affected by what you did.

(And yes, I meant delete the existing password and add the new password.)
 
D

Dave Peterson

You can unprotect a sheet by:
Tools|Protection|Unprotect Sheet

You may have to supply a password.
Terminology?. Not too sure about it myself.
I'm talking about a single sheet , [Sheet1] with 4 pages.
Thanks for the other info.
 
B

Bob I

chequer said:
Thanks, Dave,
It is a single worksheet.
Where you said, (delete the existing and add the new version), I take it
that this means, (delete the existing PASSWORDand add the new PASSWORD).
While waiting for a reply I unprotected the work sheet, copied it to a new
worksheet then deleted the sheet that I had removed the protection from.
When I had done this I didn't bother to protect the newly created worksheet
as I have a password to open my computered.
Wouldn't this give all my files protection?.

Only if the intruder didn't use a password reset CD.
 

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