Toggle PivotTable Filter for All Pivots on a Worksheet

Hi All

I've managed to get the below code working. It toggles the "Has Exclusion" pivot filter between '(All)' and 'No'
But I have 8 more pivot tables on the same sheet!

Please Login or Register  to view this content.

All the tables have the same filter field called "Has Exclusion"
Is there any way to adapt this code so that it effects all 9 pivot tables at once?

Thank you everyone
Vicky

Maybe something like this ?

Please Login or Register  to view this content.

Oh my gosh Karmapala!

Several hundred workbooks all with 5-10 pivots on the last worksheet. I can't tell you how much time this will save instead of doing them all one by one!

Thank you so much

You're welcome, vwhite.
Glad I can help .