Excel VBA run hyperlink

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