Filter not working in a protected file
 

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

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