Hyperlink Question

[Jaye7]

Say I have a value in a cell which is the hyperlink address, what VBA script would I need to run the hyperlink, based on whatever value is in the activecell at the time, either to a cell location or web address.

I.e I run a macro and it creates and follows the hyperlink.

cell value = Sheet1!A1 (it would go to that cell)

cell value = www.mrexcel.com (it would go to that web site)

Thanks.

 

[tweedle]

Something like this would follow the 1st hyperlink of a selected range

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    If Target.Hyperlinks.Count <> 0 Then
        Target.Hyperlinks(1).Follow
    End If
End Sub

 

[Jaye7]

Thanks for your reply Tweedle,

The script is not really what I am after as there are no hyperlinks in the cells just values/ references which I need turned into hyperlinks and then followed.

I have found some scripts to make hyperlinks, so I will check those out and then use a follow hyperlink script.

Thanks again.