Pivot table Filter event

[haissk]

Hi Experts,

I want to call some function only when the pivot table page item filter is selected and not on row item filter. please let me know how to do that

thanks
Sathish

[DonkeyOte]

You could possibly use the Worksheet Change event on the sheet containing the PT to test to see if Target altered is within the PivotTable's Page Range, eg:

Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, PivotTables("PivotTable1").PageRange.Columns(2)) Is Nothing Then Exit Sub
'otherwise altered cell is a page field...

End Sub

[jeffreyweir]

I've just written a series of posts on how to do this:
http://dailydoseofexcel.com/archives...date-part-one/
http://dailydoseofexcel.com/archives...date-part-two/
http://dailydoseofexcel.com/archives...ate-part-tres/
http://dailydoseofexcel.com/archives...te-episode-iv/