Forum Discussion

Copper Contributor

Jul 02, 2025

Filter Button Greyed Out on Protected Sheet Despite Filtering Enabled

Hi, I'm working on a shared Excel workbook that includes data entry areas on the left and a protected table on the right which uses the data from the left to perform calculations. Before protecti...

MVP

Jul 03, 2025

One of the options can be using VBA to Add a custom button:

Sub ClearAllFilters()
    Dim ws As Worksheet
    Set ws = ActiveSheet

    If ws.AutoFilterMode Then
        ws.ShowAllData
    End If
End Sub