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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with Macro Security 1
VBA word change keys 0
disable shortcut key sheet tab 8
To disable pressing of Enter key on a sheet 1
Disable Outlook AutoCorrect with GPO 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Responding to Keypress event on a sheet 1
WORD VBA Search and switch to advanced ... 1

Top