How to prevent copying of cell data
Category: Excel Security And Password Protection
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
', '
Related Pages:
- Excel Security And Password Protection
- Password Recovery Software
- Excel Password Recovery and Removal
- Introduction to Excel Security
- How to prevent copying of cell data
- Excel WorkBook Protection
- How to run a VBA macro on a protected sheet
- How to protect an Excel sheet with VBA Macro Code
- How to make a user enable Excel macros
- Excel Worksheet Protection
- Excel Security Patches
- Instantly Unprotect Excel Files
- DATA ERROR[47 OF 94 93 F4 K5] Virus and Corrupted Excel and Word file
- Instant Word and Excel password remover