I need to set a slicer in a pivot table by using VBA so that I can limit a number of filters the user choose.
I mean if the user choose, for example, more than tree options in a slicer a warning message box pop up on the screen.
This slicer I am talking about is based only in one field on the table.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!