Hi Everyone!
I have a summary workbook which links to 6 other workbooks which all have different passwords to open them. I want to be able to open the summary workbook and update the links without having to type in all the passwords for each linked workbook. I was told the best way is to run a VBA script to open each linked workbook with its associated password. Can someone please help me out with the code. I am still learning VBA and any help is greatly greatly appreciated. Where do I start?

Thanks,
Julie