How to prevent copying of cell data

Excel protection does not prevent users from copying data from protected sheets.It is not easy to prevent this but the code below will stop users from copying a range of data. It will not stop them from copying the data one cell at a time (a time-consuming process), but it is deterrant.If a user selects a range of cells then the macro will deselect the range and clear the clipboard of any copied information.Place this code in the corresponding VBA macro sheet.

Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Rows.Count > 1 or Target.Columns.Count>1 Then Cells(Target.Row, Target.Column).Select Application.CutCopyMode = FalseEnd Sub

', '
"Yes, Excel can do that!"
© 2000-2014 All rights reserved.