I am using Excel 2000 and I have created a template for reporting with
protected cells.

Cells which I allows for data input are unprotected.

Problem is, the cells protection does not protect for changes in cell
format (I have coloured all unprotected cells with yellow background).

When someone do a copy and paste, the format of the unprotected cells
will be changed.

The only way I can think of is to intercept "CTRL-V" or the normal
paste function and change it to "Paste as Text".

How can I do this?

Please help.

Selection.PasteSpecial Paste:=xlPasteValues, Operation:= _
xlNone, SkipBlanks:=False, Transpose:=False


--
moglione1
------------------------------------------------------------------------
moglione1's Profile: http://www.excelforum.com/member.php...o&userid=26414
View this thread: http://www.excelforum.com/showthread...hreadid=538369

What I meant was when a person presses on the Paste icon or "CTRL-V",
instead of pasting like usual (i.e. with all formats etc), it will
only paste as text without any format.

use the selectionChange event

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Application.CutCopyMode = False
End Sub


of course if macros are disabled, then this won't help

--
Regards,
Tom Ogilvy


" wrote:

What I meant was when a person presses on the Paste icon or "CTRL-V",
instead of pasting like usual (i.e. with all formats etc), it will
only paste as text without any format.