Disable Key Events

S

Seth

How can I disable key events such as ctrl-break so that a
user cannot stop a macro from running?

Thanks,

Seth
 
C

Chip Pearson

Seth,

You can use the EnableCancelKey setting. E.g,.

Application.EnableCancelKey = xlDisabled
'
' your code here
'
Application.EnableCancelKey = xlInterrupt

Use the xlDisabled setting with caution. If you get in to an infinite loop,
there is no way to get out other then Ctrl+Alt+Delete to close Excel.
 
Top