View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default 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?