Allow pivot table filters on a protected sheet

[cmb80]

Hello everybody, I have code as below to auto protect my worksheet - however it does not let me apply filters to my pivot tables after the sheet has been protected (I mean select specific dates from the date field etc).

Can someone let me know what else i need to add to the code so when the workbook is protected but I can still modify my pivot tables

Code:

For Each wSheet In Worksheets
        wSheet.Protect Password:="********", _
        DrawingObjects:=True, _
        Contents:=True, _
        Scenarios:=True, _
        UserInterFaceOnly:=True, _
        AllowFiltering:=True

[ChemistB]

AllowUsingPivotTables:=True

Does that work for you?

[cmb80]

Yes thank you - I had that part but just wasn't adding in the ,_ after the filtering