Prevention of entering Break Mode in VBA

Hi,

I am trying to figure out how to prevent pausing/interrupting the VBA code on my worksheets.
Adding a password to the VBA code still allows everyone to enter Break Mode and bypass all codes on the worksheets.
I have tried using:

Application.EnableCancelKey = xlDisabled

And have tried immediately shutting down the interrupt key by using:

If Application.EnableCancelKey = xlInterrupt Then
Application.EnableCancelKey = xlDisabled
End If

My knowledge of VBA is pretty basic so help would be very much appreciated!

Kr, Simon

Hi & welcome to ExcelForum!

The EnableCancelKey property is always reset to xlInterrupt whenever Microsoft Excel returns to the idle state and there's no code running. To trap or disable cancellation in your procedure, you must explicitly change the EnableCancelKey property every time the procedure is called. It's recommended to use this property very carefully. If you use xlDisabled, there's no way to interrupt an infinite loop or any non – self-terminating code. Also, if you use xlErrorHandler but your error handler always returns using the Resume statement, there's no way to stop your code.