MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Disabling Ctrl+Break


Posted by Dank on August 02, 2001 9:32 AM

Afternoon,

Does anyone know how I can prevent a user from stopping my macro by pressing Ctrl-Break, preferably a method that doesn't use the Onkey method.

Thanks,
Dan.


Posted by Ivan F Moala on August 02, 2001 8:04 PM

Look up online help for;

EnableCancelKey Property

breifly;

xlDisabled = Cancel key trapping is completely disabled.
xlInterrupt = The current procedure is interrupted, and the user can debug or end the procedure.
xlErrorHandler = The interrupt is sent to the running procedure as an error, trappable by an error handler set up with an On Error GoTo statement. The trappable error code is 18.

Ivan

Posted by Dan K on August 03, 2001 1:49 AM

Ivan you're a star!

Regards,
Dan.