| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 -- freekrill ------------------------------------------------------------------------ freekrill's Profile: http://www.excelforum.com/member.php...fo&userid=7561 View this thread: http://www.excelforum.com/showthread...hreadid=489041 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
code break message box
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
code break message box
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can you entre a bar code into a excel cell? | Excel Worksheet Functions | |||
| VLOOKUP for Zip Code Ranges | Excel Worksheet Functions | |||
| Conform a total to a list of results? | Excel Worksheet Functions | |||
| Concatinate a filename | Excel Discussion (Misc queries) | |||
| Each Click of the Mouse | Excel Discussion (Misc queries) | |||
Linear Mode
