Hyperlink to an already opened workbook

[dbmccallum]

I have a master workbook which opens several child workbooks (1 to 99 workbooks). I have macros to open and close all the child workbooks. Each child workbook is a business case for a project and the master workbook summarizes and combines all the projects.

I modify the child workbooks and the master summaries the results. I am looking for an easy way to navigate from the master to a problem child, the one that looks out of whack and needs modification. So I had created a hyperlink on the list of childs so I can quickly navigate to that workbook. Prior to Excel 2016, my hyperlinks worked. Now, Excel wants to reopen the child, which causes me to lose data, and it doesn't even go the workbook. I just want the hyperlink to navigate to the already open spreadsheet.

Any ideas?

Code I am using:
Do While stoprow >= indexz
Target_Workbook = xlscope.Sheets("Project Input").Range("A" & indexz).Value
Target_Name = xlscope.Sheets("Project Input").Range("D" & indexz).Value
Selection.Hyperlinks.Add Anchor:=Selection, Address:=Target_Workbook, _ SubAddress:="Command!A1", ScreenTip:="goto " & Target_Name
indexz = indexz + 1
Loop