Hi guys,

This is my first post, so please let me know if I did something wrong.
I just discovered the world of slicers and am also fairly new to VBA (not a good combination).
I have a workbook with several pivot tables in different sheets. All tables are connected with the same slicer.
I would like to achieve the following:
If a user clears the filter for Slicer "Core_Brands", the macro goes to sheet "DisbByBrand" and hides the individual fields from group "Core Brands 2" (to change the view in a pivot graph).
If not all items are selected in slicer "Core_Brands", the macro goes to sheet "DisbByBrand" and unhides the individual fields from group "Core Brands 2" .

So far I tried to achieve the first condition but even this didn't work. 

Please Login or Register  to view this content.
Do you have any idea how to solve this?

Thanks,
Juju