Slicer selection to preserve pivot table formatting using VBA

[Pavan Kumar Sistla]

Hello,

Could you please let me know the code to do the below task:

1) I have inserted a slicer and every time I click on it, the columns widths, borders and row heights are changed.

Kindly let me know how to use vba code to retain the column widths, borders and row heights etc. the moment each time slicer is clicked and the values get updated and changed in pivot table.

Thank You and Regards,
Pavan.

 

[Chihiro]

No need at all for code.

Just make sure you check/uncheck the option in PivotTable options.

 

[Pavan Kumar Sistla]

Thank you for the reply Chihiro. However, it is not working and I have googled for solution in various websites. But, none of them could give me the answer. So is the reason for me to reach out here.

The moment we click on slicer, the column widths and borders and row heights are getting changed though I have check marked the option suggested by you above.

Regards,
Pavan.

 

[Chihiro]

Upload a sample. There is no simple code that can accomplish what you are looking for, and I suspect there's more to it than what you describe.