FollowHyperlink event not working RRS feed

  • Question

  • Cell A1:


    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. 


    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 (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