Hi murkaboris

Unprotect the worksheet
Turn Autofilter on
Protect the worksheet and in the protect dialog check "Use AutoFilter"

If you have a very old version of Excel and not see this option in the protect sheet dialog post back

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




"murkaboris" wrote in message ...
Hello:

I was wondering if there is a way to make the autofilters work while the
sheet is protected. Specifically I have created List of Values for certain
column and want to limit the users choosing from them and not be able to
change any other fields that are already typed in thus the protection.

The List of values seems to work fine with the protection but the
Autofilters are not working.
Is there a way to make them function while keeping the worksheets protected?

Please help.
Thank you.

Monika