I suppose you could use a Worksheet_Change event.

Read more about them here

http://www.mvps.org/dmcritchie/excel/event.htm

HTH,
Barb Reinhardt



"joemeshuggah" wrote:

anyone know what the vba code is to run your macro when a pivot table is
updated via making a new selection in the page field of the table?