Restrict Excel from using all the paste methods

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