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

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