I have a sheet (Office 2007) that has a lot of hyperlinks. I am adding code to the Worksheet_FollowHyperlink sub. I need to be able to capture where that hyperlink was called from. This event seems to be an "after" not "before" event. When I ask for the active cell, it gives me the cell on the destination sheet. Is there something to give me the last active cell?
I have tried ...
target.address
target.SubAddress
target.name
target.creator
target.range
and can not find a way to identify where the hyperlink was called from. I am looking form somethink like targer.anchor, but that does not seem to exist.
Thank you for your help,
sabloomer
I have tried ...
target.address
target.SubAddress
target.name
target.creator
target.range
and can not find a way to identify where the hyperlink was called from. I am looking form somethink like targer.anchor, but that does not seem to exist.
Thank you for your help,
sabloomer