Hi

I have an excel file which requires a password to open (no password needed to modify) - and it is my file, so I know the current password.

Is it possible to write a macro which will change the password to the value specified in a particular cell e.g. cell A1?

Many thanks.