Posted 8 September 2017, 2:51 pm EST
Recently my boss asked to me adding function hyperlink like the MS excel.
if we write to excel Vba code,
Sheets("P&L").Hyperlinks.Add Anchor:=Sheets("P&L").Cells(1, 1), _
Address:="", SubAddress:=Cells(5, 5).Address
But, I think that the farpoint hyperlink support just only website address.
How to link other sheet or other cell using the HyperLink?
And, perhaps if not support this feature using hyperlink class, do I need to use the cellClickEvent? (if clicked, SetActiveSheetIndex...)
If I do work like this one, this feature can't do work when I export Excel files.
Please apply to me.