The problem also exists if you copy data from one cell to another within the
sheet. I have a sheet in which unlocked cells are used for data entry. As
much of the data entry is often repeated, users tend to make a single data
entry then copy and paste it throughout the sheet as required. This causes
chaos with formatting of cells as the formatting is also copied. If anyone
from Microsoft ever reads this I think this is a basic problem that needs
fixing in the next update of Excel. Locking formatting does not help.
--
A Human


"Yorck" wrote:

Gord,
That works if you want to protect the cell formatting from the user trying
to change it within the same worksheet. Nevertheless, if a user cuts and
pastes cells from another worksheet or workbook the formatting is altered
regardless of format protection settings setup on the worksheet. Is there
anyway to shut-down the loophole so users cannot alter cell formatting by
using cut and paste, but can still enter value and number formats into the
cell?
- 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?