Allow autofilter on protected sheet (via vba)

[MickeyGreen]

I'm trying to use the following code to allow the user to autofilter a protected sheet but it isn't working. Anyone know why?

With Sheet1
       .Protect Password:="yyz", DrawingObjects:=True, Contents:=True, UserInterfaceOnly:=True, _
        AllowFormattingCells:=True, AllowFormattingColumns:=True, AllowFormattingRows:=True, _
        AllowFiltering:=True
       .EnableOutlining = True
       .EnableAutoFilter = True
    End With

[MickeyGreen]

Anyone?

Bueller?

[MickeyGreen]

SON of a B.....................................!

FYI: It only works if you load the autofilter while the sheet is unprotected. But it then allows the user to select from the filter options.

[Leith Ross]

Hello MickeyGreen,

You will have to unprotect the sheet before you can use AutoFilter on it. AutoFilter will hide and unhide rows depending on the filteri outcome. These operations alter the Worksheet which is what protecting it prevents.

Sincerely,
Leith Ross

[MickeyGreen]

Hello MickeyGreen,

You will have to unprotect the sheet before you can use AutoFilter on it. AutoFilter will hide and unhide rows depending on the filteri outcome. These operations alter the Worksheet which is what protecting it prevents.

Sincerely,
Leith Ross

Poke poke you owe me a coke!