Preventing users from breaking code with ESC

  • Thread starter Thread starter joost
  • Start date Start date
J

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
 
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
 
Back
Top