How to apply a filter to a Pivot Table with a macro?

[AdrienDevoe]

Hello, I would like to apply a filter to all Pivot Tables in the sheet.
Like for example, enabling the case-sensitive or the no duplicate for all the pivot talbes with a macro.

Do someone have an idea? Thank you!!

[fpy]

depending how far you’ve reached already …
first step probably : Macro to get results from Pivot Table / Data Pilot - #2 by karolus

and Guidelines for asking - #4 by jimk

[Villeroy]

Install the MRI extension or Xray and inspect your spreadsheet document.
Every spreadsheet document has a collection of sheets (one sheet at least).
Every sheet has a collection of pivot tables.
Every pivot table has a filter descriptor.

[sokol92]

Look here in the attached file for an example of a macro that sets a filter.