have you tried programmatically unprotecting and re-protecting the
sheet?
ActiveSheet.Unprotect "YourPassword"
Selection.AutoFilter Field:=4, Criteria1:=vFilterItem
ActiveSheet.Protect "YourPassword"

Charles

Steven wrote:
I have a sheet that is protected but I checked the box that says allow auto
filter and it works fine except if I run a macro where I capture what I want
to filter in a variable and try to do the auto filter in the macro it returns
and error telling me the sheet is protected.

This is what I use in the program to filter:

Selection.AutoFilter Field:=4, Criteria1:=vFilterItem

What am I not doing?

Thank you for your help.

Steven