Trigger Macro On changing a filter of a piot table

[retnec]

I wish to trigger(execute) a macro when I change a filter of a pivot table. How can I do this?

 

[prasaddn]

Hi Retnec,


you can use a simple worksheet_change event to find if the filter value is changed, and call the required macro.


example:

Private Sub Worksheet_Change(ByVal Target As Range)

If Not Intersect(Target, Range("$C$4")) Is Nothing Then

MsgBox "You can call your macro function here"

'Use macro code or Call macro here..

End If

End Sub

Here Range("$C$4") is the cell where you have the pivot filter..


Hope this helps.


Regards,

Prasad DN

 

[Kyle McGhee]

You could also use this in the worksheet module

[pre]

Private Sub Worksheet_PivotTableUpdate(ByVal Target As PivotTable)
code here
End Sub

[/pre]
This fires with all changes to the pivot table however.