Updating links to password protected workbooks

[RobbieL]

Hi,

I have a set of monthly workbooks into which data is dumped on a month end basis.

I have set up and created a summary workbook which groups all of the monthly figures (by linking to the monthly workbooks) and displays it in a variety of ways.

The problem is that in order to protect the monthly data, I have had to password protect (to open) each monthly sheet.

Now when I open the summary report, it prompts me to update links which is fine, but then prompts me to enter the password for each month.

Is there anyway I can insert some code to automatically update the links without having to supply the password for each monthly summary?

Thanks in advance