Macro to open password protected files

[sarahips]

I have a series of workbooks, all are password protected and all link into one central workbook, which is also password protected.

When you open the central spreadsheet you have to input the passwords to all the linking files and I know that I can programme excel to input the passwords for me:

Workbooks.Open "C:\Windows\Desktop\Book2.xls", Password:="password1"
etc

However the problem is that although I have constructed this series of workbooks I am not allowed to know the passwords so I cannot programme them myself and those who will be using the spreadsheets know very little about excel.

I want to know if there is a way to input each password onto a spreadsheet within the central workbook (sheet1), e.g. "password1" will be entered in cell "A1", and then when the macro runs it will take the password from the cell rather than it being written in the macro.

This may sound like it defeats the object of having passwords but only the person that has the password to the central workbook would be able to see the spreadsheet containing the password.

I hope that makes sense, thanks for any help you can give.