I'm got a pivot table in a sheet called "Pivot" which when the user drills down into the pivot by double clicking it opens up a new sheet with the data. I wanted the event handler to run a macro after the users double click. Got the below code but not working.
Any thoughts ??
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, _ Cancel As Boolean) If ActiveSheet.PivotTables.EnableDrilldown and _ Not(Intersect(Target, ActiveSheet.PivotTables(1).TableRange2) Is Nothing) _ Then Call FillColours End Sub
Thanks in advance