ExcelBanter - run macro on pivot refresh

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - run macro on pivot refresh (https://www.excelbanter.com/excel-programming/415162-run-macro-pivot-refresh.html)

joemeshuggah

run macro on pivot refresh

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?

Barb Reinhardt

run macro on pivot refresh

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?

All times are GMT +1. The time now is 01:15 PM.