Could anyone please assist?
I need to have Autofilter on a Protected Excel worksheet, but I can't seem
to get it working.
I know the same thing can be done in Excel itself (Set the Autofilter, then
Tools, Protection, Protect Sheet, Enable Autofilter), but I need to do it in
programmatically, using an ActiveX Script task in DTS.
Have tried using the code below which shows the Autofilter in the Excel, but
I can't use, doesn't allow me to click on the drop-down arrows.

xl.ActiveSheet.Range("A1","F1").AutoFilter
xl.ActiveSheet.Protect