Disable Ctrl-Break for auto open macros.

[Sagiv Levi]

Hi there,

I want to disable the ctrl-break when auto open macros are running, how do I do it ?

Thanks for the all the help so far,
Sagiv

 

[J.E. McGimpsey]

I want to disable the ctrl-break when auto open macros are running, how do I
do it ?

Within your auto macro, use

Application.EnableCancelKey = xlDisabled

Note that this can be very dangerous if your code goes into a
non-terminating loop, etc. See the VBA Help topic "EnableCancelKey
Property"