none
FollowHyperlink event not working RRS feed

  • Question

  • Cell A1:

    =HYPERLINK("#Sheet2!a2","link")

    Sheet->View Code

    Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
    MsgBox ("hello")
    End Sub

    MessageBox does not open when I left click on A1; instead, #Sheet2!a2 opens. 

    Why?

    I don't want to use SelectionChange event unless there are way to specific the hyperlik .

    Saturday, March 1, 2014 12:20 PM

All replies

  • Re:  Follow Hyperlink Event

    Looks like it only works if you insert a hyperlink; doesn't work using a formula.
    '---

    Jim Cone
    Portland, Oregon USA
    https://goo.gl/IUQUN2 (Dropbox)
    (free & commercial excel add-ins & workbooks)

    • Edited by James Cone Sunday, October 30, 2016 11:06 PM
    Saturday, March 1, 2014 6:32 PM