Select all the column not to be protected;
Use Format | Cells | protection and deselect the Lock box
Now Tools | Protect | worksheet
Does this give you what you want?
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email
"Kinnaird" wrote in message
...
I am trying to password protect a column of single cells but it keeps
protecting the whole work sheet can ant one help?