Run code on clicking hyperlink....

[matthewjapp]

How is it possible to run code on click of hyperlink in cell?

 

[AlphaFrog]

• Right click on the sheet tab that has the hyperlinks
• Select View Code in the pop-up menu
• Paste the code below in the VBA edit window
• "Target" is the Hyperlink you clicked on

Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
    [COLOR="Green"]'Your code here[/COLOR]
End Sub

Events And Event Procedures In VBA

 

[matthewjapp]

Brilliant, thanks for this....!