MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Don't allow Esc to stop macro

Posted by Paul on April 28, 2001 2:48 AM

How do i stop Esc being pressed to stop the macro when it is running?

Posted by Dave Hawley on April 28, 2001 3:04 AM

Hi Paul

I take it you mean Ctrl+Break.

Application.EnableCancelKey = xlDisabled

OzGrid Business Applications

Posted by . on April 29, 2001 8:31 AM

The Esc key does the same as Ctrl+Break