Excel Help: How to prevent copying of cell data

Excel Security and Excel Password Protection

www.DotXLS.com
"Yes, Excel can do that!"

Related pages:
Instantly Unprotect Excel Files
Instant Word and Excel password remover
Excel Worksheet Protection
Excel WorkBook Protection
Introduction to Excel Security
How to make a user enable Excel macros
How to protect an Excel sheet with VBA Macro Code
How to run a VBA macro on a protected sheet
Excel Security Patches
Password Recovery Software
Excel Password Recovery and Removal

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 = False
End Sub

Home

Excel Consulting
Excel Security and Protection
Free Microsoft Excel Templates
Excel Calendars

Excel Corrupt File Recovery
Excel File Converters
Free Excel Help Resources
Excel Books
Excel Training

Excel Software
Business Templates
Stock Market
Financial Analysis

Scheduling

Project Management
Construction Calculators
Cost Estimating
Manufacturing

Excel BarCodes
Contact

Privacy Policy

Online Word and Excel password removal in under 3 minutes!