Hi Max, I tried your suggestion and when I try to uncheck the locked on the
cells withing the column, I get an error message "cannot change part of a
merged cell". In my invoice sheet I need to protect only the area H15 to H29
and leave the rest of the sheet unprotected so data can be added. Any
suggestions?
Luada
"Max" wrote:
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
|