Thanks Jim that works great.
I have my sheets very hidden with code that unhides them on open. If macros
are not enable they can't see anything.

"Jim Rech" wrote:

Actually there are many instances of the Copy command (32) sprinkled among
the commandbars. To get them all:

Sub DisableCopyCtrl()
Dim Ctrls As CommandBarControls
Dim Ctrl As CommandBarControl
Set Ctrls = CommandBars.FindControls(, 19)
For Each Ctrl In Ctrls
Ctrl.Enabled = False
Next
End Sub

Be sure to Enable on exit as this change is saved in the user's
configuration.

But you know if the user disables macros when opening your workbook he'll be
able to copy as he pleases...

--
Jim
"Firkins" wrote in message
...
|I have a excel file that I'm trying to prevent someone from saving as or
| coping data. I have disabled the "Save", "Save as..", and the copy
commands.
| But I notice when someone select the entire sheet (Ctrl - A) the copy
command
| is still available on the right click menu. How do I disable this?