Worksheet_FollowHyperlink

[maarire]

I created a link to a cell using the Hyperlink function as followed:

[FONT=Lucida Grande]=HYPERLINK("#'Sheet24'!C4"; "Hyperlink to cell C4")
[/FONT]

Here I ran into a first problem: the hyperlink works (directs me to the cell), but it displays the entire function instead of "Hyperlink to cell C4". (which isn't very neat)

Then I want to assign the hyperlink to a macro function. (I need specific code according to the target cell's address)
Until now I only found the following solution: put the following code into "sheet24"-excel-object module:

[/FONT]Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
    MsgBox "test"
    ' Do something with Target.Range.Address
End Sub
[FONT=Lucida Grande]

Sadly this isn't working.

Some who knows how to assign a macro to a hyperlink?


Thanks