Disable Ctrl-Break for auto open macros.

S

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

J.E. McGimpsey

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

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"
 
Top