Filter not working in a protected file

J

jijy

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
 
R

Ron de Bruin

Hi

Unprotect your sheet
Turn on AutoFilter
Tools>Protection>Protect sheet
Mark "Use AutoFilter"
Protect your sheet
 
Top