VBA to cut and paste to destination format

[Livin404]

Good evening, I have a simple VBA where I can have the use Cut and Paste (Ctrl-v) and ensure the Format is kept on the destination worksheet rather than the source format. I appears to work fine, but I notice the user could still right click see the paste option and end up using the source format. Is there a way I can lock pasting options, so "ONLY" the destination format can be used? The VBA I used is.

Thank you,

Sub PasteWithDestinationFormatting()

ActiveCell.PasteSpecial (xlPasteValues)

End Sub

 

[cortexnotion]

You could use Application.CutCopyMode = False after your code to clear the clipboard which will prevent any further paste of the data.