Macro creates a set of slicers (about 200!) and sets position and properties as it goes. But I'm stymied: no way to force slicer to be in "multi-select" mode when it's created? Do I really need to go through each slicer after it's created and click the multi-select icon on each one? [ I did...
I am working on preparing a scorecard for our team, and what I want to create is a dashboard where we can select a user via a drop down, and it will update the scorecard for that user.
There are 3 data points that we are looking at for performance: 1) Cycle time 2) External...
Currently I have a system in place that will update a slicer based upon ONE value that is chosen from a drop down box.
See code below:
Application.ScreenUpdating = False
Application.EnableEvents = False
Application.Calculation = xlCalculationManual