How to protect cells from being copied or cut
You can't without getting into macros. If you want a macro solution then
something like this should do... right click the sheet tab and select View
Code. Paste the following.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Application.CutCopyMode = False
End Sub
--
HTH...
Jim Thomlinson
"Chris" wrote:
I have a data that is entered on a daily basis by others. I need to keep them
from being able to copying or cutting and pasting existing data from one cell
or goup of cells to another. I can protect the cells from everything but
copying or cutting.
|