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
|