Disable Key Events
 

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

Thanks,

Seth

Disable Key Events
 

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.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com


"Seth" wrote in message
...
How can I disable key events such as ctrl-break so that a
user cannot stop a macro from running?

Thanks,

Seth