S Seth Oct 6, 2003 #1 How can I disable key events such as ctrl-break so that a user cannot stop a macro from running? Thanks, 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 Oct 6, 2003 #2 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.
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.
