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
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