Auto Filter & Protecting Worksheet
 

Hi there

I want to be able to protect the worksheet so that users can only enter into
the data entry cells but also allow them to use the AutoFilter feature to
quickly search through the records.

When I set the protection feature I can not click on the AutoFilter arrows.
Can I change this?

Thanks for your help, Silena

Auto Filter & Protecting Worksheet
 

See
http://www.contextures.com/xlautofilter03.html#Protect

--

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


"Silena K-K" wrote in message ...
Hi there

I want to be able to protect the worksheet so that users can only enter into
the data entry cells but also allow them to use the AutoFilter feature to
quickly search through the records.

When I set the protection feature I can not click on the AutoFilter arrows.
Can I change this?

Thanks for your help, Silena