Macro to show report filter pages from a Pivot table

[TopLearner]

Good afternoon everybody,

I hope you are well,

I would like to create a macro to be able to do this Pivot table function that you can find in the ribbon under "PivotTable Analyze" > PivotTaable Options> show report filter pages.
Can anybody help me, please?

Thanks
Sanchez

 

[Fluff]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Macro to show report filter pages from a Pivot table
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[TopLearner]

Hi everybody,

I hope my question makes sense. It is just an extra step to be added to VBA in order to save up some time.
Thanks
Sanchez

 

[TopLearner]

I have found a solution

ActiveSheet.PivotTables("PivotTable1").ShowPages PageField:="MyReportFilter"