Hi Mike......
Thanks for the comeback. I understand that it's worksheet code, in this
instance and workbook code when I try it there, but neither seem to fire.
The Hyperlink I'm using opens another file, then I want to run a macro
located in the original file against that newly opened file. But NOTHING
happens....I don't even get the msgbox popup.

My Hyperlink was created by recording a macro and editing it, rather than
using original code.....it that makes a difference.

Might I have some Excel setting set wrong?

Vaya con Dios,
Chuck, CABGx3



"Mike H" wrote:

Hi,

Works fine for me. You have to have it as worksheet code as opposed to in a
general module.

Mike

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