Filtering lists while sheet is protected.

[dlangham]

:idea:

I am working in Excel 97 and have found that I cannot filter lists while the worksheet is protected. Is there any way to get around this limitation?

Thanks in advance for your help. :idea:

David

 

[Jotoya]

I was personally not aware of this. Thank you Juan Pablo.

 

[dlangham]

Thank you all. As usual you have come through with flying colors. It works as suggested.

David

 

[Juan Pablo González]

My gf has 2003 Beta on her computer...I'll check tonite.

Not available on 2003 Beta 2....

 

[Tom Urtis]

Thanks a heap JPG...that means me and the gf won't have anything to talk about tonite.

 

[rnarayanan]

I have an issue while filtering when the sheet is protected. Could anyone help me in clearing this issue?