View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
massi[_2_] massi[_2_] is offline
external usenet poster
 
Posts: 51
Default column/sheet protection

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