How can I Autoupdate Vlookup links when the other workbook is open?

I have two workbooks, "Test1" and "Test2" each with a sheet inside. The code is inside the "Test1" workbook, inside the "ThisWorkbook" module.
​
I have a Vlookup in the sheet "Mytest1" inside the "Test1" workbook, that simply does a Vlookup with workbook "Test2" inside sheet "Mytest2". Both workbooks are password protected, I am having an issue where if I have the workbook "Test2" opened on another computer, I get a prompt to "Enter Password" for "Test2" when I open my "Test1" workbook.
​
I have posted screenshots below of both workbooks and code, alongside the code itself. Please ask me any questions to clarify anything.

Please Login or Register  to view this content.

code.JPG
test1.JPG
test2.JPG

Thank you, worked flawlessly!

Originally Posted by fshbet

Hi,

You can just open the file as readonly. use the code below

Please Login or Register  to view this content.

I meant to say thank you to your reply, not just the post!