maintain format on pivot table

Hello

I use this macro to maintain the formatting of the table,

I have to launch the macro each time I filter some of the "report filter" fields

is it possible to have the macro kick in when I change the filter ?

Thanks for Reading

Please Login or Register  to view this content.

Originally Posted by AlphaFrog

• Right-click on the pivot table's worksheet tab
• Select View Code from the pop-up context menu
• Paste the code from below in the worksheet's code module
• Change the E2 to the cell that has the "report filter" field

This code should automatically trigger when you make a change to that cell

Please Login or Register  to view this content.

it worked!! thank you !!