Protection and Filtering

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Khalil handal - 12 Dec 2007 06:37 GMT

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

Reply to this Message

Dave Peterson - 12 Dec 2007 12:16 GMT

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

> 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

Signature

Dave Peterson

Reply to this Message

Khalil handal - 12 Dec 2007 12:39 GMT

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

> Tools|Protection|Protect sheet
> Make sure you check the "allow autofilter" option.
[quoted text clipped - 5 lines]
>> Any solution??
>> Using Excel 2003

Reply to this Message

Dave Peterson - 12 Dec 2007 14:37 GMT

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+?

> Hi,
> did what you said but still the Auto filter is not active.
[quoted text clipped - 13 lines]
> >
> > Dave Peterson

Signature

Dave Peterson

Reply to this Message

Khalil Handal - 12 Dec 2007 16:55 GMT

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

> What does "autofilter not active" mean?
>
[quoted text clipped - 21 lines]
>> >
>> > Dave Peterson

Reply to this Message

Rate this thread: