Trigger macro with Pivot Chart Field Button

Any custom formatting is lost when a pivot chart is refreshed and although it's possibe to write a macro to reformat it, it has to be triggered with a button or key stroke.

Unlike Access there don't seem to be any event properties for a pivot chart field button so is there another way to have the macro run whenever the field button is refreshed?

Thanks

Mike Collard

VBA code for executing a macro
DoCmd.RunMacro ("MacroNamePlacedHere")


S-