Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Enabling Events | Excel Discussion (Misc queries) | |||
Events won't Disable! | Excel Discussion (Misc queries) | |||
events? | Excel Discussion (Misc queries) | |||
VBProject events? | Excel Programming | |||
Hyperlink events | Excel Programming |