Hide/Show all slicers

This is something that I have used quite often.

Slicer options can be added to a user form which gets shown when a button is clicked, after selecting required slicer option the form will close again.

Have a look here: http://www.contextures.com/excelpopu...rselector.html