File protection

[lynn]

I thought I posted this yesterday, but I can't find it
anywhere. -

I want to be able to protect a worksheet, but also allow
others to be able to use Autofilter. I don't see a way to
do this in Excel 2000. IN 2002, when I go to Tools -
Protection - Protect sheet, there is a list of things I
can allow others to do, and Autofilter is in the list.
however, even when I select this, autofilter is still
greyed out.

Can anyone tell me if this can be done, in either 2000 or
2002 ?

 

[Laura Cook]

Lynn-

Here is Gord Dibben's response to your post from yesterday:

___________________

lynn

First select the columns to filter then Data>Filter>Autofilter to get the
drop-down arrows showing.

NOW Tools>Protection>Protect Sheet and check "Use Autofilter".

Your Autofiltering will work now on the protected sheet.

____________________