Protection in Excel

gbaker · #1 02-28-2013, 06:56 AM

Hi Tony,
I did protect cells that I didn't want anyone to be able to edit. These are cells that need to be edited but I don't want anyone to be able to cut & paste, Just copy and paste so I won't have reference issues on other sheets that are in the background. I found code that seems to work well for what I am trying to do.

Code:

Option Explicit
Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, _
ByVal Target As Excel.Range)
Select Case Application.CutCopyMode
Case Is = False
'do nothing
Case Is = xlCopy
'do nothing
Case Is = xlCut
MsgBox "Please DO NOT Cut and Paste. Use Copy and Paste; then delete the source."
Application.CutCopyMode = False 'clear clipboard and cancel cut
End Select
End Sub

Thanks for your help!!!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Password Protection	JimP	Visio	2	03-24-2011 04:23 AM
Document protection	Daved2424	Word	0	11-17-2010 01:22 AM
Help reg Protection of cell.	aligahk06	Excel	1	09-02-2009 05:45 PM
need help with document protection	jknyc	Word	1	06-22-2009 11:47 PM