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!!!