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

--
Cheers
Nigel

Hi Nigel,

See VBA help for the EnableCancelKey property.


---
Regards,
Norman



"Nigel" wrote in message
...
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

--
Cheers
Nigel

Hi Nigel,

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?

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


---
Regards,
Norman
Microsoft Excel MVP

Many thanks - all is now clear

--
Cheers
Nigel



"Norman Jones" wrote in message
...
Hi Nigel,

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?

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


---
Regards,
Norman
Microsoft Excel MVP

Try this


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

Mike
"Nigel" wrote:

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

--
Cheers
Nigel