Prevent window movement when linking from one Excel workbook to another
Posted on 2014-12-06
How do you prevent window movement when using hyperlinks between different Excel (2013) workbooks?
For example, suppose you have two workbooks (A.xlsm & B.xlsm) open and you position then side-by-side on your screen with A to the left and B to the right. And suppose you create a hyperlink in workbook A to a given cell in workbook B.
When the hyperlink is clicked in A it does jump to the destination cell in B as expected but at the same time, the window containing workbook B changes its screen position to perfectly overlie workbook A, thus obscuring the contents of workbook A.
A little experimenting revealed that the same screen position change occurs when the target is a bookmark in a Word doc (ie the window containing the Word doc moves to obscure the Excel window) but does not occur when the destination is a website. In other words, the browser window in which the destination website opens, remains where it is on the screen.
How can you create a link from one Excel workbook to another and have the window containing the latter maintain its original position?