Livin404
Well-known Member
- Joined
- Jan 7, 2019
- Messages
- 743
- Office Version
- 365
- 2019
- Platform
- Windows
Greetings, I have a VBA with key commands Ctrl +V to ensure that when that command is executed it will keep the destination format. Is there anything else I can do, so no matter how data in pasted into my worksheet the destination formatting cannot be overwritten? Unfortunately, I have to look at the lowest denominator, so there will be individuals that somehow manage to use the source format. My goal is to make it nearly impossible to do. In other words they all the normal ways of posting will not allow the destination format to be altered. Thank you,
VBA Code:
Sub PasteWithDestinationFormatting()
ActiveCell.PasteSpecial (xlPasteValues)
Application.CutCopyMode = False
End Sub