Help with linking to multiple password protected source workbooks.

[Xtrimmer]

Hello,

I have been given the task of creating a summary workbook that will link to and summarize information in 16 different source worksheets. The problem is that each of the 16 source worksheets are password protected with a different password to open. While I have all the passwords to access each source sheet, the problem lies in that I must enter all 16 different passwords for the source sheets consecutively every time in order to update the information on the summary worksheet! My question: Is there a feature that allows a master password or way to use a macro/vba to enter all the passwords for you when updating the summary sheets?

Thanks you in advance for any suggestions!

 

[namazin2]

Hello,

I have been given the task of creating a summary workbook that will link to and summarize information in 16 different source worksheets. The problem is that each of the 16 source worksheets are password protected with a different password to open. While I have all the passwords to access each source sheet, the problem lies in that I must enter all 16 different passwords for the source sheets consecutively every time in order to update the information on the summary worksheet! My question: Is there a feature that allows a master password or way to use a macro/vba to enter all the passwords for you when updating the summary sheets?

Thanks you in advance for any suggestions!

I have to imagine you figured out the answer to this question in the last four years, yeah? If so... what did you find out?