Copying and Pasting Cells 1

[tigercrap]

I have a protected workbook that i sent out to other personnel and all they have to do is data entry. How can i prevent someone from copying cells and pasting them over other cells on the same worksheet or workbook?

Thanks
Tim in Iraq

 

[lupins46]

If the worksheet is protected then they cannot do anything to the protected cells. Is there some info missing from your Q?

 

[tigercrap]

Well the unprotected cells are for data entry, so I am trying to prevent someone from copying any cells over those unprotected data entry cells. Thanks for replying!

Tim in Iraq

 

[xlbo]

Not without code

If you want to use code then this will take care of most attempts to copy/paste

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Application.CutCopyMode = False
End Sub

This would go in the WORKSHEET module

Rgds, Geoff

"Three things are certain: Death, taxes and lost data. Guess which has occurred"

Please read FAQ222-2244 before you ask a question

 

[tigercrap]

Great...I'll try that. I was going to try also:

Application.CopyObjectsWithCells = False

I appreciate your help!

Tim in Iraq