PivotTable: Need to detect when user selects new value for dropdow

  • Thread starter Thread starter JHop
  • Start date Start date
J

JHop

I have a pivot table/pivot chart that has three dropdowns for the Page, Row
and Column. I need to make some format changes to the chart any time the
user changes one of them. Is there some event I can capture so that my code
will run when a change is made?
 
Which version of XL are you using. The pivot table engine changed
dramatically in XL2002...
 
Thanks for responding, but in the meantime I stumbled on the answer myself in
the object browser--there's a Worksheet_PivotTableUpdate event that did the
trick. I'm using Excel 2003.
 
Back
Top