Hi Javier,
I have protected a sheet and autfilter doesn´t work.
pls. post your excel version.
starting with excel 2002 (xp) you can allow filters in protected
workbooks in the options of Extras/Protection/SheetProtection
(translated from german).
when using xl 2000 and older you need a macro including these lines to
activate outlining and autofilter before protecting the sheet:
ActiveSheet.EnableAutoFilter = True
ActiveSheet.EnableOutlining = True
regards
arno
|