Hi
you can use the worksheet_followhyperlink event to achieve this. E.g.
put the following code in your worksheet module
Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
If Target.Range.Address = "$A$1" Then
'insert your code here
End If
End Sub

The above will process your code if the hyperlink in cell A1 is
invoked.

HTH
Frank

Kevgrn114 wrote:
How do I make a hyperlink that will run a specified macro when
clicked?