Hi,

I am trying to protect a formulated cell however when I do this I loose the
autofilter? Is there a way to do this and still keep the autofilter?

thanks

There is an option in protection to allow autofilter. Check that option .

--
__________________________________
HTH

Bob

"Emily" wrote in message
...
Hi,

I am trying to protect a formulated cell however when I do this I loose
the
autofilter? Is there a way to do this and still keep the autofilter?

thanks

But don't forget............the autofilter must be enabled before sheet
protection is set.


Gord Dibben MS Excel MVP

On Mon, 1 Sep 2008 11:59:41 +0100, "Bob Phillips"
wrote:

There is an option in protection to allow autofilter. Check that option .

I may have been presumptuous Gord, but he said that he loses the autofilter,
so I assumed he had one.

--
__________________________________
HTH

Bob

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
But don't forget............the autofilter must be enabled before sheet
protection is set.


Gord Dibben MS Excel MVP

On Mon, 1 Sep 2008 11:59:41 +0100, "Bob Phillips"
wrote:

There is an option in protection to allow autofilter. Check that option .

Keyword being "loose"(sic)..................didn't read all of OP as usual.

Gord

On Mon, 1 Sep 2008 22:27:48 +0100, "Bob Phillips"
wrote:

I may have been presumptuous Gord, but he said that he loses the autofilter,
so I assumed he had one.