I have hundred of files to which I want to link specific cells in one sheet.
The thing is, all of those file are password protected.

Now obviously when I open my sheet, I get hundreds of prompt for passwords.

Fortunately, the password is the same for all the sheets.
Is there a way I supply by code or else the requested password?

Does anyone have a suggestion on how I should go about this?


TIA
Dniss