how can i fix one entire column after putting my formula there so.
 

how can i fix one entire column after putting my formula there so no one can
edit it
--
Hozefa N Jhabuawala

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

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

Try this sequence instead for your case ..

Press CTRL+A to select the entire sheet
Click Format Cells Protection tab
Uncheck "Locked" OK

(we unlock the entire sheet first)

Select the target range H15:H29
Click Format Cells Protection tab
Check "Locked" OK

(then we lock only the target range)

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

And if the above doesn't work, then ..

Try unmerging the entire sheet first

Instead of using merged cells to centre across cols
(e.g.: for col labels), consider:

Format Cells Alignment tab
Under Text alignment:
Horizontal Centre across selection

(merged cells can be a real pain <g)
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Luada" wrote in message
...
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