URL through Pivot Table

[newdelhi01]

Hi
I have an excel sheet with data about products and live web url links. The data is Part#,Description,Price,Category and a live web URL. When the users click on the URL it takes them to the actual web page. When I pivot the same data, the URL links get converted to text and donot have a click option to take the user to the web page. I am attaching a screen shot of the pivot. How can I make the URL as active live links so that the user can reach the web page through the Pivot also
http://i1223.photobucket.com/albums/dd514/newdelhi01/Pivot.jpg

Any help is deeply appreciated

Thanks

 

[BrianB]

Hopefully this will do what you want :-

'=============================================================================
'- DOUBLE CLICK A CELL (string not a hyperlink) TO OPEN A WEB PAGE
'- Brian Baulsom October 2010
'- ** this macro goes into the Worksheet code module
'-    right click the tab & View Code
'=============================================================================
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
    Dim IE As Object
    Dim MyURL As String
    Const READYSTATE_COMPLETE As Integer = 4
    On Error GoTo WebError
    '------------------------------------------------------------------------
    MyURL = ActiveCell.Value
    Set IE = CreateObject("InternetExplorer.Application")
    With IE
        .Visible = True
        .navigate MyURL
        '---------------------------------------------------------------------
        '- WAIT UNTIL THE WEB PAGE IS OPEN
        Do Until .ReadyState = READYSTATE_COMPLETE
            Application.Wait Now + TimeValue("0:00:01") ' WAIT 1 SECOND
            DoEvents
        Loop
    End With
    '-------------------------------------------------------------------------
    Set IE = Nothing
    Beep
    Exit Sub
    '-------------------------------------------------------------------------
WebError:
    MsgBox ("Could not open " & MyURL)
End Sub
'=============================================================================