Hi, I am new to this VBA and need help.
I have found this code to assign Ctrl + v to copy and paste as values only to my template workbook for 20 users. It seems to work; howerver, when the workbook is closed and users try to use "Ctrl + v" as normal; then, this VBA workbook open again
. Please help review the code if there is something wrong and how to fix it? Thank you!
The below code is in "Module 2":
AND
Then, in "ThisWorkbook" I have the below code:
I have found this code to assign Ctrl + v to copy and paste as values only to my template workbook for 20 users. It seems to work; howerver, when the workbook is closed and users try to use "Ctrl + v" as normal; then, this VBA workbook open again
. Please help review the code if there is something wrong and how to fix it? Thank you!The below code is in "Module 2":
VBA Code:
Sub CreateShortcut()
Application.OnKey "+^{v}", "KeepDestinationFormatting"
End SubAND
VBA Code:
Sub KeepDestinationFormatting()
If ActiveWorkbook Is ThisWorkbook Then
ActiveSheet.Selection.PasteSpecial Paste:=xlPasteValues
End If
End SubThen, in "ThisWorkbook" I have the below code:
VBA Code:
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Call Module2.KeepDestinationFormatting
End Sub
Last edited by a moderator:
