
Solution to trigger hyperlink
Use FollowHyperlink function to go to a website.
Public Sub hyper()
ThisWorkbook.FollowHyperlink Range("C6").Value
End Sub
For details of the FollowHyperlink, check out the below article
Excel VBA function FollowHyperlink
Read More