2007 Excel Protecting a cell
 

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?
--
Linda K

2007 Excel Protecting a cell
 

Unlock the cells.

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


Gord Dibben MS Excel MVP

On Mon, 1 Feb 2010 09:58:02 -0800, LindaAlex
wrote:

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?

2007 Excel Protecting a cell
 

That was a easy fix!! Thanks
--
Linda K


"Gord Dibben" wrote:

Unlock the cells.

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


Gord Dibben MS Excel MVP

On Mon, 1 Feb 2010 09:58:02 -0800, LindaAlex
wrote:

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?

.

2007 Excel Protecting a cell
 

That was an easy fix, Thanks.
--
Linda K


"Gord Dibben" wrote:

Unlock the cells.

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


Gord Dibben MS Excel MVP

On Mon, 1 Feb 2010 09:58:02 -0800, LindaAlex
wrote:

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?

.