Worksheet change with pivot table
Using: MS OS XP
Excel 2003
I have a pivot table that needs to be reformatted each time you change data.
For example going from all years to 2003. I have created a macro that will
re-format as needed.
I have found no way to trigger this macro except manually via a control. I
would like the macro to run every time the worksheet changes due to making
different selections.
I have tried the worksheet change event but it doesnt seem to work on the
pivot table, I can get it to work on a regular worksheet.
Please help.
Thanks in advance.
--
Richard
|