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