Hyperlink Link_location from Other Worksheet

Ardmore7

New Member
Joined
Mar 11, 2009
Messages
7
Goal: Workbook A obtains link_location argument from Workbook B for use in hyperlink function in Workbook A, where link_location is based on active cell reference in Workbook B.

Problem: the user-defined function used to generate Workbook B active cell reference changes when Workbook A is opened.

Background: I have a "Jeopardy"-type game in Excel for which I would like to jump to pictures pasted into other Excel files. I would like the "picture" file to contain a link (e.g., hyperlink, macro button, etc) that will return the screen to the "answer" (i.e. name of person or object pictured).
 

Some videos you may like

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

Watch MrExcel Video

Forum statistics

Threads
1,108,732
Messages
5,524,512
Members
409,583
Latest member
RedHelp

This Week's Hot Topics

Top