VBA Pivot table only bring details of user

Hello, I am trying to look for some code for a Pivot Table for multiple users in excel 2007. What I would like to do is when some one opens the Pivot table Excel on their PC it will look at their Username and only bring back the information for themselves in the pivot table. I am fairly new to VBA so your help in this matter would be much appreciated. below is the code for creating the Pivot table which I recorded using the record Macro function.

Sub gggggggg()
'
' gggggggg Macro
'

'
ActiveWorkbook.Worksheets("Sheet1").PivotTables("PivotTable1").PivotCache. _
CreatePivotTable TableDestination:="Sheet5!R3C2", TableName:="PivotTable2" _
, DefaultVersion:=xlPivotTableVersion10
Cells(3, 2).Select
ActiveWindow.SmallScroll Down:=-12
End Sub