hi james

the answer is quite simple. the default protect sheet does not allow the
use of autofilter.
when you apply protect sheet option and the dialog box opens, scroll down to
the bottom and you will see a
Use Autofilter box, just check this, and you should be ok.



"James" wrote in message
...
I am using excel 2007, I set up the auto filter and it works fine. I
protect
the worksheet and I selected the "Use auto filter" option. Then the auto
filter does not work. What am I doing wrong?