Protection and Filtering

K

Khalil handal

Hi,
Have formulas in an Excel sheet. Protected the sheet to avoid changing
formulas by mistake or deleting them.
The problem now is that Auto Filter doesn't work!!
Any solution??
Using Excel 2003
 
D

Dave Peterson

Tools|Protection|Protect sheet
Make sure you check the "allow autofilter" option.
 
K

Khalil handal

Hi,
did what you said but still the Auto filter is not active.
Other sugestions!!
 
D

Dave Peterson

What does "autofilter not active" mean?

I could still filter any range by any field and any value--as long as the filter
was already applied to the range before the worksheet protection was done.

I use xl2003. Are you sure you're using xl2002+?
 
K

Khalil Handal

You are right, I tried the filtering AFTER the protection and NOT BEFORE it.
Now it workd fine.
Thanks
 
Top