View Single Post
  #2   Report Post  
Max
 
Posts: n/a
Default

Assuming the col with the formulas is col C,
with data input in say, cols A and B

Try this:
Select cols A & B
Click Format Cells Protection tab
Uncheck "Locked" OK

Then just protect the sheet via:
Click Tools Protection Protect Sheet [Password?] OK

This'll protect every cell on the sheet (inclusive col C)
other than cols A and B

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Hozefa" wrote in message
...
how can i fix one entire column after putting my formula there so no one

can
edit it
--
Hozefa N Jhabuawala