I tricked it somewhat but it works: the trick is to use the sub
address to go to a specific cell. That cell is monitored with the
Worksheet_SelectionChange event. And in that event your procedure or
function is called.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Select Case Target.Address
Case "$C$1"
Call SomeProc
Case "$C$2"
Call SomeProc2
End Select
End Sub

I did make a sample file, I shall upload HyperlinkRunProc.xls.