Guys,

I have protected workbook but I've allowed using pivot tables in it. Users of this excel file can sort data with slicers. I want disable users to clear all filters when activate clear button from data tab. I've tried this:

Application.CommandBars("Edit").Controls("Clear"). Enabled = False

But clear button is still active.

Any suggestions?