Solved

Prevent window movement when linking from one Excel workbook to another

Posted on 2014-12-06
3
126 Views
Last Modified: 2014-12-24
Hello,

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?

Thanks
0
Comment
Question by:WeThotUWasAToad
3 Comments
 
LVL 29

Expert Comment

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

Can you post an example ?
gowflow
0
 
LVL 27

Accepted Solution

by:
Glenn Ray earned 500 total points
ID: 40489297
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).

Regards,
-Glenn
0
 

Author Closing Comment

by:WeThotUWasAToad
ID: 40517337
Thanks Glenn
0

Featured Post

Active Directory Webinar

We all know we need to protect and secure our privileges, but where to start? Join Experts Exchange and ManageEngine on Tuesday, April 11, 2017 10:00 AM PDT to learn how to track and secure privileged users in Active Directory.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we discuss how to recover the missing Outlook 2011 for Mac data like Emails and Contacts manually.
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
This Micro Tutorial well show you how to find and replace special characters in Microsoft Word. This is similar to carriage returns to convert columns of values from Microsoft Excel into comma separated lists.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question