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
Bookmarks