Restrict Excel from using all the paste methods

Source: Internet
Author: User

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

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.