Disable Stopping a Macro while running

cjcobra · May 1st, 2002, 01:43 PM

I want to disable someone from pressing CTRL+Break &/or Esc while the macro is running. I tried the following, but the keys still stop the macro while it is running.

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

Any clue?

Damon Ostrander · May 1st, 2002, 04:06 PM

Hi cjcobra,

Try

Application.EnableCancelKey = xlDisabled

but be careful. Disabling cancel is dangerous, especially if there is any possibility of an infinte loop. Make sure your code is thoroughly checked out and tested before setting it.

cjcobra · May 6th, 2002, 01:07 PM

That worked! I have a countdown that needs to be completed before the next set of code.

Thanks!

May 1st, 2002, 04:06 PM	#2
Damon Ostrander MrExcel MVP Join Date: Feb 2002 Location: Denver, Colorado USA Posts: 4,014	Hi cjcobra, Try Application.EnableCancelKey = xlDisabled but be careful. Disabling cancel is dangerous, especially if there is any possibility of an infinte loop. Make sure your code is thoroughly checked out and tested before setting it. __________________ Keep Excelling. Damon VBAexpert Excel Consulting (My other life: http://damonostrander.com )

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 1st, 2002, 01:43 PM	#1
cjcobra Board Regular Join Date: Apr 2002 Posts: 177	I want to disable someone from pressing CTRL+Break &/or Esc while the macro is running. I tried the following, but the keys still stop the macro while it is running. Application.OnKey "{ESCAPE}", "" Application.OnKey "^{BREAK}", "" Any clue?

May 6th, 2002, 01:07 PM	#3
cjcobra Board Regular Join Date: Apr 2002 Posts: 177	That worked! I have a countdown that needs to be completed before the next set of code. Thanks!