I am using columns A-L with content. I want certain cols to be protected
as they bring inthe dynamic content.

Firstly, I selected the whole worksheet [ctrl+a], right clicked and
took the tick out of Locked, I then highlighted the whole of cols G, H,
I & K by clicking on the column letter and checked the Locked box. I
then highlighted the whole of row 1 as this is the column headers and I
have auto-filter running and unchecked the Locked box. Then I applied
the protection so the cells can't be changed.

But now the auto-filter won't work. Is this a known problem with
Excel?

I'm using Excel 2000 [9.0.2720]

Ta
Ian


--
iwgunter
------------------------------------------------------------------------
iwgunter's Profile: http://www.excelforum.com/member.php...o&userid=15441
View this thread: http://www.excelforum.com/showthread...hreadid=513526