I am using the following code to paste data in my worksheet
Selection.PasteSpecial Paste:=xlValues
When I use this method the undo button became disabled, so I cannot be
able to undo the pasting.
If I use the Excel's PasteSpecial command the undo button is enabled
and I can be able to undo the changes.

How can I make the undo button be enabled so that I can undo the paste
done using PasteSpecial method?

Thank you
John