Gord,
That works for protecting the overall format within the worksheet; however,
if you cut and paste cells from another worksheet or workbook the formatting
gets changed regardless of format protection settings. Is there any way to
lock down and protect cell formatting so that the user cannot change it using
a cut and paste method? I am trying to limit cell entry strictly to values
and number formats. Any ideas?
- Yorck

"Gord Dibben" wrote:

John

If using Excel 2002 or 2003 and ToolsProtectionProtect Sheet you will find
options to tick on or off.

"Format Cell" is one of these options.

Unlock the cell for data entry then protect the sheet.


Gord Dibben Excel MVP

On Tue, 22 Feb 2005 02:49:02 -0800, "John Louis"
wrote:

I want to protect the cell format like in a sheet protection of a cell, so
that for other users can change the content of the cell but not use 'Format
Cell Number' to chage the format let say from a time to a %

"John Louis" wrote:

In excel how do I protect the format of a cell but let the user change the
cell value?