Livin404
Well-known Member
- Joined
- Jan 7, 2019
- Messages
- 743
- Office Version
- 365
- 2019
- Platform
- Windows
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,
Thank you,
VBA Code:
Sub PasteWithDestinationFormatting()
ActiveCell.PasteSpecial (xlPasteValues)
End Sub