User Interupt Prevention

Posted by Michele on June 25, 2001 7:43 AM

How do I prevent a user from interupting the running of my code, i.e., how do I prevent the user from using the "Ctrl + Break"?
Thank you,
Michele

Posted by Ivan F Moala on June 25, 2001 12:08 PM

Application.EnableCancelKey = xlDisabled

Have a look @ onlne help for EnableCancelKey
There are some cautionss to be aware of particuarly if you are just writingthe routine
and it hasn't been fully tested. Suggest you only
put this routine in after Testing is OK.

Ivan