Protecting sheet with VBA and enable filtering

[karolina1406]

hiya,
I am using Sheets("overview").Protect Password:="my password" code for protecting my tab in the spreadsheet. When protected the user cannot use filtering. Can I somehow protect my tab and allow users to filter columns?

 

[Jaafar Tribak]

Sheets("overview").Protect Password:="my password", AllowFiltering:=True

 

[karolina1406]

Sheets("overview").Protect Password:="my password", AllowFiltering:=True

doesn't work...

 

[Jaafar Tribak]

doesn't work...

The filter must be on turned on before protecting the sheet.

 

[karolina1406]

The filter must be on turned on before protecting the sheet.

fixed it! Had to plugged AllowFiltering:=True in other places in my code.... Thank you very much

 

[Jaafar Tribak]

fixed it! Had to plugged AllowFiltering:=True in other places in my code.... Thank you very much

You are welcome.