Excel Formatting

[Emily]

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

 

[Bob Phillips]

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

 

[Gord Dibben]

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


Gord Dibben MS Excel MVP

 

[Bob Phillips]

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

 

[Gord Dibben]

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

Gord