Autofilter not working when the sheet is password protected

[mudflap]

After I password the excel sheet the autofilter portions do not work on my excel sheet.
Microsoft website said add the following but I can't get it to work.

Private Sub Workbook_Open()
Sheet1.Protect password:="sas", DrawingObjects:=True, contents:=True, Scenarios:=True, userinterfaceonly:=True
Sheet1.EnableAutoFilter = True
End Sub

Thanks
Peter

 

[GlennUK]

Hi Peter,

do you have autofilter switched on in this sheet? ( i.e. when it is saved )

This code will enable an existing filter to operate, it won't switch on autofiltering.

Glenn.