Hi Jimmar

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

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Jimmar" wrote in message ...
I am using MS Excel 2000 and I want to password protect a worksheet to
protect the format and formulae but still allow users to use the filter
facility. Is this possible?