Elkar
That code produced a "Variable not defined" error on the word "None" in
the Workbokk_Activate macro. Did you leave anything out? Thanks. Otto
"Elkar" wrote in message
...
I've run into this problem myself. It can be solved quite simply with
just a
few lines of VB Code. Add this code to your workbook (use Alt-F11 to open
the VB Editor, then double-click "ThisWorkbook", then copy/paste the below
code)

Private Sub Workbook_Activate()
Application.CutCopyMode = None
End Sub

Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target
As Range)
Application.CutCopyMode = None
End Sub


NOTE: If the user disables macros when the workbook is opened, then this
won't work.

HTH,
Elkar



"Rod from Corrections" wrote:

I work in a correctional centre. Some of the correctional officers have
little training to use Excel or other programs, but are required to
complete
spreadsheets on line. Although we have heavily protected the worksheets
and
locked cells, we find that in some cases the staff can still mess up the
worksheets by copying and pasting data inappropriately.

Is there a way to turn off the ability to paste data into the worksheet,
and
to force each field to be completed manually? This would eliminate the
problem.