I think you need to unprotect your sheet, select the column then righ
click in the highlighted area choose format cells choose protectio
then click on protection and make sure the check box for locked i
ticked, once you have done this you need to go to tools, protection
protect sheet (if you have excel 2003 then you have a list of option
which says Allow the user to:- uncheck the select locked cells), yo
must make sure any other cell you do not wish to be locked has had th
locked check box cleared.

Hope this helps!

Simo

--
Simon Lloy
-----------------------------------------------------------------------
Simon Lloyd's Profile: http://www.excelforum.com/member.php...nfo&userid=670
View this thread: http://www.excelforum.com/showthread.php?threadid=27549