By default, all cells are locked. When you protect the worksheet
(Tools menu), all cells will be protected. To protect only some
cells, first select all cells (click the gray box above the
column header and to the left of the row headers), go to the
Format menu, choose Cells, then the Protection tab. There,
uncheck the locked checkbox. The select the cells you wish to
protect, go back to the Protection tab and check the Locked
property. Then, protect the worksheet.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"GregP1962"
wrote in
message
...

Back in the good old days, when we had lotus, we could simply
protect
cells. Why doesn't Excel tell us how to protect cells? Why is
it not
simple? How do you do it?


--
GregP1962
------------------------------------------------------------------------
GregP1962's Profile:
http://www.excelforum.com/member.php...o&userid=33063
View this thread:
http://www.excelforum.com/showthread...hreadid=549713