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
|