Prevent Data Copying

How to prevent data copying from an Excel worksheet using VBA. Often we need to protect our data from being copied. Watch the training video and then watch the second video below to provide another strong layer of protection for your data:

Watch this video on YouTube.

Here’s the VBA code:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Application.CutCopyMode = False
End Sub

The next video shows how to provide another layer of protection to your data: