I created a link to a cell using the Hyperlink function as followed:
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:
Sadly this isn't working.
Some who knows how to assign a macro to a hyperlink?
Thanks
Code:
[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:
Code:
[/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