Hi all,

I am using the macro below to force user to use paste values, and it works well. However, when I have to run another macro includes copy/paste-special-values, I cannot due to the "UNDO" command.

Is there anything I can add to this macro below to allow other macros to run normally:

Private Sub Worksheet_Change(ByVal Target As Excel.Range)

If Application.CutCopyMode = xlCopy Then


Application.EnableEvents = False


Application.Undo

Target.PasteSpecial Paste:=xlPasteValues

Application.EnableEvents = True

End If

End Sub