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




chequer wrote:

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 couldnt apply it.

What are the simple steps to change my password?

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

--

Dave Peterson