Prevent window movement when linking from one Excel workbook to another


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?

Who is Participating?
Glenn RayConnect With a Mentor Excel VBA DeveloperCommented:
I almost answered this a couple of days ago, but did some extra research to confirm.  The window behavior you're seeing when clicking a hyperlink to another Excel workbook is by design.  It is not possible to have the hyperlink retain the target file's "restored" position/size inside the Excel workspace.  The fact that IE (or any browser) behaves differently is just because it's a different type of application, namely NOT MS Office-related.

While you can link to a specific cell in another workbook (using the HYPERLINK function), there's no parameter available to control the output.  In order to do that, you'd need to use automation (VBA).

What do you mean by
 create a hyperlink in workbook A to a given cell in workbook B.

Can you post an example ?
WeThotUWasAToadAuthor Commented:
Thanks Glenn
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.