Easily hide/unhide slicers without VBA?

[DME]

Hello,

Is there an easy way to hide/unhide slicers without using VBA?

I'm most curious to see if there is a way to group slicers (or other objects) with rows/columns so that the Outline < Group/Ungroup easily hides and unhides them. It doesn't seem like that works though (unless I'm completely missing something!).

If it requires VBA - is anyone able to help me set that up?

Thank you in advance for your help and insights!

NOTE: I tried to attached a sample file but seem to be receiving an error. I'll try to include if required but hoping this is straightforward enough to answer without a sample file.

Best,
Dave

 

[Chihiro]

Make sure you set the property of slicers to "Move and size with cells".



When property is set as such, it will be hidden when rows containing slicers are hidden (via hide rows or Gouping).

 

[DME]

@Chihiro thank you! I didn't realize I had changed the properties. Much appreciated.