|I created 4 workbooks, all stored on the same network drive.|
qwz.xlsm contains the macro shown to open q.xlsx, w.xlsx and z.xlsx and then close them.
qwz.xlsm pulls data from the q, w and z workbooks with a simple formula:
e.g. ='\\users\User_Name\My Documents\[q.xlsx]Sheet1'!$A$1
The q, w and z workbooks pull data from each other in a similar fashion. All 4 books are password protected.
When I run the code below, the q,w, and z workbooks open, all 4 workbooks update and the q,w and z workbooks close.
Note: As I said before, I can't replicate your exact scenario, so I don't know exactly how you are performing your task. What I have found is that when I open the qwz workbook, it wants the passwords for the other 3 password protected workbooks because of the links to those password protected workbooks. I have to cancel the password request in order to test the macro.
If you are not getting those password requests as soon as you open the Quality workbook, you are obviously doing something differently than I am.
Workbooks.Open Filename:="\\users\User_Name\My Documents\z.xlsx", _
Workbooks.Open Filename:="\\users\User_Name\My Documents\w.xlsx", _
Workbooks.Open Filename:="\\users\User_Name\My Documents\q.xlsx", _
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.