Refresh

[M]

Hi All,

How can I trigger a macro everytime the user refresh the
Pivot Table? I am new to this area. Help with this code
would be appreciated. Thanks in advance

Regards

M

 

[Frank Kabel]

Hi
you may use an event procedure for this. e.g. the
worksheet_calculate event. See
http://www.cpearson.com/excel/events.htm

 

[M]

Thanks, this works.

-----Original Message-----
Hi
you may use an event procedure for this. e.g. the
worksheet_calculate event. See
http://www.cpearson.com/excel/events.htm

.