Solved

Prevent window movement when linking from one Excel workbook to another

Posted on 2014-12-06
3
122 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
Comment Utility
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
Comment Utility
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
Comment Utility
Thanks Glenn
0

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Preface: When I started this series, I used the term CommandBars because that is the Office Object class that it discusses. Unfortunately, when Microsoft introduced Office 2007, they replaced the standard Commandbar menus with "The Ribbon" and rem…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

772 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now