View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
isabelle isabelle is offline
external usenet poster
 
Posts: 587
Default 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.