View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default Preventing users from breaking code with ESC

Hi Joost,

See VBA help for details of the EnableCancelKey Property.


---
Regards,
Norman




"joost" wrote in message
l...
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
--
Friends help you move, real friends help you move bodies.