kc.crow
12-08-2007, 05:59 PM
Hi,
Is there a way to capture a refresh or filter applied to a PivotTable as an event with which to attach code? PivotTable refreshes tend to remove formatting of column headers and was looking for a way to either set the formatting up so that I could keept it or have code re-apply the formatting.
Hopefully one of the geniuses out there can help. :dunno
Is there a way to capture a refresh or filter applied to a PivotTable as an event with which to attach code? PivotTable refreshes tend to remove formatting of column headers and was looking for a way to either set the formatting up so that I could keept it or have code re-apply the formatting.
Hopefully one of the geniuses out there can help. :dunno