Hi there

I am currently building an overview spreadsheet which links to a number of other spreadsheets. Some of these other spreadsheets are password protected.

Upon opening the overview spreadsheet you are required to enter the passwords for all the sheets it links to.

As a number of people will be using the overview spreadsheet I wanted to know if there is any VB that i can use to auto complete the password entries when the spreadsheet opens. I do not want all the relevant people to a) have to remember a number of passwords and b) then have the password to the source spreadsheets which have sensitive information on them.

Does anyone know of any code that I can use to do this?

Thanks for all your help!

Brokovich.