That did the trick Jacob...........many thanks

<mumble, so simple, why didn't I think of that? <mumble, mumble

Vaya con Dios,
Chuck, CABGx3




"Jacob Skaria" wrote:

--Check whether macros are enabled

--Did you disable the events through code...In immediate window type the
below and hit enter..then check whether events are getting fired

Application.EnableEvents = True

--
Jacob


"CLR" wrote:

Hi All.......

XL07......having trouble getting this to fire......

Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
MsgBox " this is it"
Call MyMacro
End Sub

Same with the same function in the Workbook

Any idea what I might be doing wrong?