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?
Bookmarks