Problem using ctrl+Z on copy-paste-value macro

[amphinomos]

Hi,

I use a (very) simple macro stored in the personal workbook to create a keyboard shortcut for Copy-Paste-Values (instead of using Alt+E+S+V+Enter):

Sub CopyPasteValue()
'
' Keyboard Shortcut: Ctrl+Shift+X
'
    Selection.Copy
    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
    Application.CutCopyMode = False
End Sub

Problem is you can't use Ctrl + Z on this as you can when you manually CopyPasteValues. Is there any line of code that could correct that ?

Thanks,
amphinomos

[adyteo]

No, you cannot use Undo after a macro runs.

[amphinomos]

Thanks for your help