Restricting the use of paste in Excel can effectively prevent users from copying external data to and from pasting into this workbook.
Here's how to implement the Paste feature in Excel.
First, the realization principle
Implemented using VBA code, the theoretical guidelines for implementation are:
Disable the Paste feature in the Edit menu
Disable the selective pasting feature in the Edit menu
Restrict the use of the Paste feature in the right-click menu
Restrict the use of keyboard shortcuts Ctrl + V
Ii. Methods of implementation
① code to disable the Paste feature
Private Sub Workbook_sheetselectionchange (ByVal Sh as Object, ByVal Target as Range)
Application.CommandBars ("worksheet Menu Bar"). Controls ("edit (E)"). Controls ("Paste (P)"). Enabled = False
Application.CommandBars ("Cell"). Controls (3). Enabled = False
Application.CommandBars ("worksheet Menu Bar"). Controls ("edit (E)"). Controls ("Paste selective (S) ..."). Enabled = False
Application.onkey "^v", "" "
End Sub
② restrictions on the ability to remove paste
Private Sub workbook_beforeclose (Cancel as Boolean)
Application.CommandBars ("worksheet Menu Bar"). Controls ("edit (E)"). Controls ("Paste (P)"). Enabled = True
Application.CommandBars ("Cell"). Controls (3). Enabled = True
Application.CommandBars ("worksheet Menu Bar"). Controls ("edit (E)"). Controls ("Paste selective (S) ..."). Enabled = True
Application.onkey "^v"
End Sub