How would I force an Excel hyperlink (to another spreadsheet) to open up in a new window of Excel, thereby leaving the original spreadsheet open. Currently, hyperlinks close the calling spreadsheet.
The goal is to simply click on the hyperlink. Thus far, the only way I know how to force a hyperlink to open into another window is by:
Right Click on the hyperlink, select "hyperlink/open in new window".