Maybe you can make use of the FollowHyperlink method

Direct from help file.
ActiveWorkbook.FollowHyperlink Address:="http://example.microsoft.com", _
    NewWindow:=True