Hi Ivor
There is no available functionality to do what you require, however we can use macros to get around this.
Put this macro into an empty module and assign it to a command button (use the Forms toolbar for the command button).
Sub test()
With ActiveSheet
.Unprotect Password:="password"
.ShowAllData
.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True, AllowFiltering:=True, Password:="password"
End With
End Sub
It will unprotect the sheet, remove all the autofilters and reprotect it again using password as the password (change above as required).
To remove all filters, your users just click the buton.
HTH
DominicB
Bookmarks