Preventing users from breaking code with ESC

[joost]

Hello,

I would like to prevent users from interrupting my routines globally.
assigning "{ESC}" to a macro helped slightly, but still i sometimes see
the "code execution has been interrupted" popup when i press escape.
I know about EnableCancelKey, is there something like that which would
work globally?

Thank you very much for any help/pointers you can provide.
Joost

 

[Norman Jones]

Hi Joost,

See VBA help for details of the EnableCancelKey Property.

 

[Jim Cone]

A better solution might be to speed up your code so that users don't
become impatient. If they cannot use Escape then they would have
to resort to Task Manager and close Excel - that won't help your
reputation.
You could also add a message box (when escape is pressed) asking for
confirmation that they want to exit. That would eliminate concern that
the program is not responding.
In addition, adding a progress bar or some information in the Status Bar
lets the user know that the code is working.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


Hello,

I would like to prevent users from interrupting my routines globally.
assigning "{ESC}" to a macro helped slightly, but still i sometimes see
the "code execution has been interrupted" popup when i press escape.
I know about EnableCancelKey, is there something like that which would
work globally?

Thank you very much for any help/pointers you can provide.
Joost