I guess you need to change the default behavior of the MS Excel while pasting any data on the excel sheet. particularly you have to change the behavior of the Ctrl+V which would be the perfect one. You have to use the Macros for doing this. I have given the following code which you have to add in the Personal.xlsb workbook.
- In the workbook code pane;
Code:
Sub Auto_Open()
Application.OnKey "^v", "PasteValues"
End Sub
Sub Auto_Close()
Application.OnKey "^v"
End Sub
Code:
Public Sub PasteValues()
' Keyboard Shortcut: Ctrl+v
ActiveSheet.PasteSpecial Format:="Unicode Text"
End Sub
Bookmarks