Rayne
asked on
slicer magic
Is there a VBA to multi select slicers?
Like there is a slicer group called [Rep]. I can now go and hit ctrl + the slicer values to select multiple values within the slicer group. Can the same be done with VBA – multi select slicers withn a slicer group?
slicerMagic.xlsm
Like there is a slicer group called [Rep]. I can now go and hit ctrl + the slicer values to select multiple values within the slicer group. Can the same be done with VBA – multi select slicers withn a slicer group?
slicerMagic.xlsm
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
...multi-selecting all the values like looping through the slicer
Can you explain that a bit further?
Are you wanting to loop through each item in the slicer and enable it? This would be the same as setting each item to 'True' at one time unless you introduce some other functions that need to happen as well.
Are you wanting to iterate through each item (appending it to the last one) in order to make a visual 'demo'?
ASKER
Well yes, I need to somehow loop thorugh each slicer option so that the slicer cache is updated - as that stores the selection value in the page footer. So when I open the workbook, something needs to happen so that the slicer cache is updated with those values so when I print I see the footer already refreshed
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks Sire
Not a problem!
ASKER
I was thinking of multi-selecting all the values like looping through the slicers in vba ...is that possible?
Thank you