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

Dave
OzGrid Business Applications

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

The Esc key does the same as Ctrl+Break