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

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?
--
Judy Hopkins

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

Which version of XL are you using. The pivot table engine changed
dramatically in XL2002...
--
HTH...

Jim Thomlinson


"JHop" wrote:

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?
--
Judy Hopkins

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

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.
--
Judy Hopkins


"Jim Thomlinson" wrote:

Which version of XL are you using. The pivot table engine changed
dramatically in XL2002...
--
HTH...

Jim Thomlinson


"JHop" wrote:

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?
--
Judy Hopkins