You can read about this at:
http://msdn2.microsoft.com/en-us/lib...ffice.11).aspx

You could use
With Application
.OnKey "^c", "" 'Copy shortcut disabled
.OnKey "^v", "" 'Paste shortcut disabled
End With

This basically sets these keys to nothing ("")

To enable them again, you would use
With Application
.OnKey "^c" 'Copy shortcut enabled
.OnKey "^v" 'Paste shortcut enabled
End With

Without the "" at the end, it returns them to their original state
--
Hth

Kassie Kasselman


"GR" wrote:

How to forbid ctrl+c and ctrl+X in sheet?