Thread: FollowHyperlink
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default FollowHyperlink

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