Worksheet_FollowHyperlink function (1 Viewer)

[krunalprajapati]

Hi all
Need some help.....
I have written a code in Worksheet_FollowHyperlink(ByVal Target As Hyperlink) event in a worksheet.
In Excel help(F1), the help shows this event "Occurs when you click any hyperlink on a worksheet." but when i click any hyperlink in the worksheet the event is not fired. I chked with putting a breakpoint in the event, but it is not executing.

Any suggestion? Is there anything missing in sheet's property?

Krunal.

 

[chergh]

Works fine for me. Tested with the following:

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

 

[unmarkedhelicopter]

Have you disabled events anytime recently ?
Are you SURE it's in the sheet ?