Slicer Multi Select Button

Question

When choosing multiple options in a slicer, one could use the multi select button in the top right corner with the checks.

When saving the same workbook with the slicer, upon opening it, the multi select option/button is returned back to it's off position.

Is there a way, that as soon as the user opens that workbook that the multi-select button is turn or or kept on?

Answer 1

Hi

My name is André. I am an independent consultant.

>what format are you saving the file in? because in order to work, the ideal thing is that it be .XLSM

I hope this information is useful for you. If you still have questions, answer here so I can continue helping you.

André.

Answer 2

Thanks for replying.

Yes  I have tried in both formats and the button still returns as "off".

When saving the same workbook with the slicer, upon opening it, how can I make the multi select option/button  keep in the on position.

Answer 3

Unfortunately I ran out of ideas to resolve this case, I will release the issue so that someone else can help you. good luck.

Answer 4

Thanks OK I found the answer.

Sub Auto_Open() '' SelectSlicer Macro''ActiveSheet.Shapes.Range(Array("State")).SelectSendKeys "%s"=========================================================================End Sub

Answer 5

I figured you didn't want to use VBA. but how great that you found the solution. I will end here so that your post can help other people with the same doubts. good jobs.