Protect Cell
 

I want to protect one cell "E3" on a worksheet, all other unprotected. I
have an area that is set up with the Data/AutoFilter where the dropdown
arrows go across line 6, ie below the protected cell. Here is my issue:
When I Set all the cells to Unprotected and then set E3 to Protected and
then Protect the Sheet the AutoFilter is locked and not funtional. Is there
another solution to this.

Thank you,

Steven

Protect Cell
 

When you protect the sheet scroll down the list that pops up and check
the use Autofilter box. I think that option came with Excel 2002.

Per Erik
On Sat, 21 Jan 2006 09:26:02 -0800, Steven
wrote:

I want to protect one cell "E3" on a worksheet, all other unprotected. I
have an area that is set up with the Data/AutoFilter where the dropdown
arrows go across line 6, ie below the protected cell. Here is my issue:
When I Set all the cells to Unprotected and then set E3 to Protected and
then Protect the Sheet the AutoFilter is locked and not funtional. Is there
another solution to this.

Thank you,

Steven