OK, so as it stands I have 2 files; 1.xls and 2.xls.
file1 has a macro:
Sub One()
Workbooks.Open Filename:="c:/2.xls"
MsgBox "You'll never see this message "
End Sub
and file2 has this in its ThisWorkbook:
Private Sub Workbook_Open()
Workbooks("1.xls").Close...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.