Posted to microsoft.public.excel.programming
|
|
hyperlink - place in this document - can discover caller in targetsheet?
ok
'in ThisWorkbook
Private Sub Workbook_SheetFollowHyperlink(ByVal Sh As Object, ByVal Target As
Hyperlink)
MsgBox "From : " & Sh.Name & " " & Target.Parent.Address & " to : " &
Target.SubAddress
End Sub
isabelle
Le 2014-02-22 01:34, a écrit :
Excel calls it a hyperlink but the option is set to a "place in this document".
If you edit it, doesn't look like "hyperlink" construct. Not in the mode "place in this document" anyway.
|