VBA code to hide and unhide all the Slicers in workbook.

[hananak]

Dear All,

I have a workbook with many sheets with multiple slicers in each sheet.

I am looking for a vba code that is assigned to a button, on clicking it it should hide all the slicers and again clicking it it should unhide.
The button text should change based on slicers current status (Hide/Unhide).

I would really appreciate, your help.

Thanks.

 

[Domenic]

Which line causes the error? And you can you please confirm the exact error message you're getting?