Good day.

I have a Excel file that links back to several other files. However, some
of the other files are password protected. If I know the passwords, it is
possible to pass those password using VBA and open my linked workbook without
being prompted for a password?

Each time I open the linked file I am asked for the passwords to the other
files, but the users don't want that. They do want their files protected,
however.

Any ideas?