Gord
I also want to be able to stop the formatting change in a protected sheet if
cutting and pasting cells from another worksheet or workbook. I was not able
to access the google search thread and so any suggestions you can give me
would be great.

Thank you
Doreen D

"Gord Dibben" wrote:

Yorck

Check out this google search thread.

http://snipurl.com/dn81

Dave Peterson's reply in particular for a workaround.


Gord Dibben Excel MVP

On Thu, 24 Mar 2005 14:31:05 -0800, "Yorck"
wrote:

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?