Hi Darin,

The worksheet calculate event fires when a pivot table changes. You can
launch your macro from that.

Place this code in the module for the worksheet that contains the pivot.

Private Sub Worksheet_Calculate()
call your_macro
End Sub

This will launch every time a calculation is made on that sheet. So, you
macro will run with any change in the pivot - not just page headers.

Regards,
Mike

"Darin Kramer" wrote:


HI All,

No solution yesterday - can anyone help...

Once a person has made a selection on the page header part of a pivot
table, a need to call a macro that fixes formatting and the like of
other parts of the table.
(removing auto format table or preserve format under table options
doesnt work, I need to be able to call a macro.

Any suggestions welcome

Thanks

D


*** Sent via Developersdex http://www.developersdex.com ***