Hi all,

I'm trying to apply a different custom design to a pivot table, but need to clear the background format as well to get the actual colours. Is there a command for it in VBA? No luck with below so far as it simply applies the specified design without clearing the background format... 

Please Login or Register  to view this content.
Here's the manual setting command to clarify what I mean.

PivotFormat.PNG