Password Auto fill

[cyberice]

Can anyone help me with a dilemma?

I have a number of workbooks that have been encrytped and therefore have passwords. These workbooks are linked to a master document designed to monitor changes made to each workbook. This works absolutely fine, but when I open the master workbook I am prompted to enter the passwords for each of the other workbooks! Obviously this is a tad annoying!

Is there any way that I can open the master workbook without having to enter each password?

Mick,

[FDibbins]

Do you have the password for all the other workbooks?

[LJMetzger]

Hi cyberice,

See the file associated with post #4 in the following thread which addresses a problem similar to yours: http://www.excelforum.com/excel-prog...h-a-macro.html

Lewis

[cyberice]

Hi Lewis,

Thanks for the advice, I will check it out,

Mick,