2007 Excel Protecting a cell

  • Thread starter Thread starter LindaAlex
  • Start date Start date
L

LindaAlex

I found help on this for 2003, but does not work the same for 2007. I want
to protect a format in a cell but still allow data entry. How can I do this?
 
Unlock the cells.

When you protect the sheet do not allow "Format Cells"


Gord Dibben MS Excel MVP
 
That was a easy fix!! Thanks
--
Linda K


Gord Dibben said:
Unlock the cells.

When you protect the sheet do not allow "Format Cells"


Gord Dibben MS Excel MVP



.
Click to expand...
 
That was an easy fix, Thanks.
--
Linda K


Gord Dibben said:
Unlock the cells.

When you protect the sheet do not allow "Format Cells"


Gord Dibben MS Excel MVP



.
Click to expand...
 
Back
Top