Create event triggered by 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 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 |
All times are GMT +1. The time now is 05:49 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com