Hello all,
I just created a pivot table wich lists a set of hyperlinks that i want to open in a embedded web browser.
So far i found a code that allows me to "activate" the hyperlinks so they open in IE, what i need now is instead of opening in a new IE window, that they open in the embeded browser (developer/insert/activex controls/webbrowser) .
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Cells.Count = 1 Then
On Error Resume Next
ActiveWorkbook.FollowHyperlink _
Address:=CStr(Target.Value), _
NewWindow:=False
On Error GoTo 0
End If
End Sub
Bookmarks