That bothered me for the longest time too. In the 1st open .xls file, if a field changes (say just inserting anything anywhere, then your working within the .xls file and click on a hyperlink, your 1st open .xls file will stay open. It's when there has been no change in the original .xls file that it will close it.
Not the proper fix but a simple way around it that I found to help but just simply entering like "x" in any blank field to keep my main .xls list open so that I can ALT TAB back & forth
Ahhhh, yes, that would make sense now !
thanks for the tip JC
:-)
Here are 3 lines of code that should eliminate that problem. I know this is simple, but it took me a while to figure out a solution. Hopefully it can save someone else some time.
Sub Auto_Open()
ThisWorkbook.Sheets(1).Range("z1").Value = Now()
End Sub