Hi
Unlock all the cells. Then lock only the columns you want to lock. Then
apply protection. I think the user will still by able to unhide the columns
but they will not be able to make any changes to the locked cells.


"massi" wrote:

I would like to hide a column which contains formulas that I don't want to be
shown. I made the column hidden and protect the sheet in order not ot let
unhide the column. the problem is that if I try to do operations on the other
cell like CTRL + H I get an error message saying that I cannot use the
commend in a protected sheet. As different people are going to use the file I
want to keep the protection but just in the columns with the formulas i have
created. is it possible to protect 2 cloumns only and have the rest of the
sheet able to be modified?
thanks