code break message box

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

Cheers
free

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.

Look at application.EnableCancelKey in VBA's help.



freekrill wrote:
>
> I have a code which loops until it is stopped via the esc key. When this
> happens, the message box ("Code execution has been interrupted") appears
> with the options to end, debug, etc. My question is: can I stop this
> message from appearing? That is, when I press esc, can I just have the
> page where the code was working displayed without any error messages?
>
> Cheers
> free
>
> --
> freekrill
> ------------------------------------------------------------------------
> freekrill's Profile: http://www.excelforum.com/member.php...fo&userid=7561
> View this thread: http://www.excelforum.com/showthread...hreadid=489041

--

Dave Peterson