Hi Folks

I know you can use Application.OnKey "^c","" to disable the Ctrl C copy
shortcut.

I'd like to be able to disable the Ctrl Break that interrupts code execution.

I've tried the following line of code in the Workbook Open event, but it
doesn't seem to work, although no errors occur.

Application.OnKey "^{BREAK}",""

Many thanks in Advance

Look at application.Cancelkey perhaps that will work for you.

--
Regards,
Tom Ogilvy

"Libby" wrote in message
...
Hi Folks

I know you can use Application.OnKey "^c","" to disable the Ctrl C copy
shortcut.

I'd like to be able to disable the Ctrl Break that interrupts code
execution.

I've tried the following line of code in the Workbook Open event, but it
doesn't seem to work, although no errors occur.

Application.OnKey "^{BREAK}",""

Many thanks in Advance

Take a look at:
Application.EnableCancelKey
in VBA's help.

Note the warning.

Libby wrote:

Hi Folks

I know you can use Application.OnKey "^c","" to disable the Ctrl C copy
shortcut.

I'd like to be able to disable the Ctrl Break that interrupts code execution.

I've tried the following line of code in the Workbook Open event, but it
doesn't seem to work, although no errors occur.

Application.OnKey "^{BREAK}",""

Many thanks in Advance

--

Dave Peterson

As Dave said, it is actually EnableCancelKey - Bad brain to hand connection.
:(

--
Regards,
Tom Ogilvy
"Tom Ogilvy" wrote in message
...
Look at application.Cancelkey perhaps that will work for you.

--
Regards,
Tom Ogilvy

"Libby" wrote in message
...
Hi Folks

I know you can use Application.OnKey "^c","" to disable the Ctrl C
copy
shortcut.

I'd like to be able to disable the Ctrl Break that interrupts code
execution.

I've tried the following line of code in the Workbook Open event, but it
doesn't seem to work, although no errors occur.

Application.OnKey "^{BREAK}",""

Many thanks in Advance