software

I want to protect one cell quot;E3quot; 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

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
gt; wrote:

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