Excel Formatting
 

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

Excel Formatting
 

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

Excel Formatting
 

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 .

Excel Formatting
 

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 .

Excel Formatting
 

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.