code break message box

[freekrill]

I have a code which loops until it is stopped via the esc key. When thi
happens, the message box ("Code execution has been interrupted") appear
with the options to end, debug, etc. My question is: can I stop thi
message from appearing? That is, when I press esc, can I just have th
page where the code was working displayed without any error messages?

Cheers
fre

 

[Dave O]

Will this do it for you?
Application.DisplayAlerts = False

The only other thing I can think of is to use another method of ending
the program.

 

[Dave Peterson]

Look at application.EnableCancelKey in VBA's help.