Hello,

Is it possible to disable the copy function as set ctrl-c or in the edit
pulldown menu.

Stefan

Hi Stefan,

Yes, the command is:

Application.CommandBars("Worksheet Menu
Bar").Controls("Edit").Controls("Copy").Enabled = False

HTH
Carim

I'll admit ignorance on the subject of disabling it in the drop down menu,
but you should be able to disable the ctrl+c function by directing that hot
key to a sub that does nothing. Example
sub workbook_open ()
application.onkey "^{c}", "Idonothing"
end sub
sub Idonothing ()
end sub
--
When you lose your mind, you free your life.


"Stefan Buijs" wrote:

Hello,

Is it possible to disable the copy function as set ctrl-c or in the edit
pulldown menu.

Stefan

You can disable the copy by simply adding a selectionchange event macro. The
macro does not have to day anything but it will keep the user from being able
to copy.

HTH

"Stefan Buijs" wrote:

Hello,

Is it possible to disable the copy function as set ctrl-c or in the edit
pulldown menu.

Stefan