-
1
- #1
write a macro thus
Function apppath() As String
apppath = "[" & ActiveWorkbook.FullName & "]"
End Function
cell formulae in the hyperlink cells are
=HYPERLINK(apppath() & "sheetname" & "!A1","legend"
"sheetname" can be an INDEX or INDIRECT computation.
"legend" is whatever text you want to be visible
This was necessary so I could give the xls away and it is not pre-ordained where it will be stored on the HDD (or wherever)
It does recalculate whenever the cursor hovers over the cells containing it but I tried other options and this was the best for many reason - I didn't want an Aut
pen macro.
Function apppath() As String
apppath = "[" & ActiveWorkbook.FullName & "]"
End Function
cell formulae in the hyperlink cells are
=HYPERLINK(apppath() & "sheetname" & "!A1","legend"
"sheetname" can be an INDEX or INDIRECT computation.
"legend" is whatever text you want to be visible
This was necessary so I could give the xls away and it is not pre-ordained where it will be stored on the HDD (or wherever)
It does recalculate whenever the cursor hovers over the cells containing it but I tried other options and this was the best for many reason - I didn't want an Aut
pen macro.