Refresh
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 |
Refresh
Hi
you may use an event procedure for this. e.g. the worksheet_calculate event. See http://www.cpearson.com/excel/events.htm -----Original Message----- 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 . |
Refresh
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 -----Original Message----- 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 . . |
All times are GMT +1. The time now is 10:40 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com