Excelpromax123
Board Regular
- Joined
- Sep 2, 2021
- Messages
- 172
- Office Version
- 2010
- Platform
- Windows
I want to lock Ctrl V for only 1 sheet . But still want to allow copying from one file to another, and files without the above code can still Ctrl V. I'm currently using the code below, but it doesn't allow Ctrl V to move to another file. Thank you !
VBA Code:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Application.OnKey "^v", ""
End Sub
Private Sub Worksheet_Deactivate()
Application.OnKey "^v"
End Sub