I created 2 Password Protected Excel Workbooks and 1 Master Excel Workbook. The Master Excel Workbook are linked to the 2 Password Protected Excel Workbooks to get the data from them. Whenever I open the Master Excel Workbook, there will be a prompt asking do I want to update or not and I click "Update Link," but another prompt will follow asking for a password. The password prompt will reoccur every time I open the Master Excel Workbook. I was hoping to find a way to have the Master Excel Workbook contain the two passwords, so the next time I open the Master Excel Workbook, I won't have to type in the password.

I created a new module in Visual Basic and have tried this code but it doesn't seem to work:
Formula: copy to clipboard 
Sub Open()

  Workbooks.Open Filename:= "C:\Users\UserName\My Documents\File1.xlsx", Password:="Secret1"

  Workbooks.Open Filename:= "C:\Users\UserName\My Documents\File2.xlsx", Password:="Secret2"

End Sub


Thank you very much for any help provided. I have been googling and trying to figure out different method but the password prompt still shows up.