Disable Ctrl-Break

[Nigel]

Two questions....

How can I disable the Ctrl-Break key strokes to prevent stopping code when
it is running?

If I do disable the Ctrl-Break - is there a way I can set up my own 'break'
command sequence to stop the code running?


Thanks

 

[Norman Jones]

Hi Nigel,

See VBA help for the EnableCancelKey property.

 

[Mike H]

Try this


sub nobreak()
Application.EnableCancelKey = wdCancelDisabled
your code
Application.EnableCancelKey = wdCancelInterrupt
end sub

Mike

 

[Norman Jones]

Hi Nigel,

To specifically address the second question, VBA help
provides an example of the use of a custom cancellation
handler.

 

[Nigel]

Many thanks - all is now clear