View Single Post
  #2   Report Post  
Ron de Bruin
 
Posts: n/a
Default

Hi

Unprotect your sheet
Turn on AutoFilter
ToolsProtectionProtect sheet
Mark "Use AutoFilter"
Protect your sheet



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


"jijy" wrote in message ...

I am working on a protected file and the filters are not working in the
protected mode. How can I aloow filtering data while keeping the file
protected? I am using excel 2003.

Thanks,

Jijy


--
jijy
------------------------------------------------------------------------
jijy's Profile: http://www.excelforum.com/member.php...o&userid=15042
View this thread: http://www.excelforum.com/showthread...hreadid=392552