Disable Ctrl and/or Alt Key

[Danny]

Is there a a macro command to disable the Ctrl and or the
Alt key so the user can't override my macros with shortcut
keys? I tried the OnKey method but I have to write a macro
for every shortcut key.

 

[arno]

Hi Danny,

so the user can't override my macros with shortcut
keys? I tried the OnKey method but I have to write a macro
for every shortcut key.

use
Application.EnableCancelKey = xlDisabled
at the beginning of each makro, you do *not* have to set back to "xlenabled"
because this happens automatically when the code has finished.

regards

arno

 

[Danny]

Hi Arno,

Thanks for our tip. However, it didn't work. As I said,
I wrote some onkey macros to disable shortcut keys,
examples below:

Application.OnKey "%{F8}", ""
Application.OnKey "^c", ""
Application.OnKey "^x", ""

I have to write more macros for other shortcut keys. I
think I inserted your macro "Application.EnableCancelKey =
xlDisabled" in the wrong place.

Regards,
Danny