Auto Filter and protection does it work?

[Mike54]

I wonder if can anyone help me please. I am trying to use auto filter on a worksheet and I also want to use protection so that other users cannot alter the data.
I created the worksheet in Excel XP but but am distributing on Excel 2000 and it won't allow me to protect the sheet and use autofilter. Any ideas please

i.e.
It works on XP but not 2000
Many thanks

 

[Legacy 12630]

This should work in XL2000 :-

Private Sub Workbook_Open()

With ActiveWorkbook.Sheets("Sheet1")
.EnableAutoFilter = True
.Protect Contents:=True, userInterfaceOnly:=True
End With

End Sub