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).
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).
