Avoiding macro run for terminating by user

[escelinen]

Hello,

is it possible to avoid user to terminate macro? If I have quit long
macro running, which is processing several actions in many sheets, I
don't want anybody to terminate macro by pressing *Ctrl-Break*. If that
happens, it would be catastrophic for my workbook to run correctly next
time somebody wants run a macro again.

 

[Gary Keramidas]

maybe something like this

' Macro to turn off keyboard entry.
Sub KeyboardOff()
' Sets CTRL+D to activate KeyboardOn.
Application.OnKey "^d", "KeyboardOn"
Application.DataEntryMode = True
End Sub

' Macro to restore keyboard entry.
Sub KeyboardOn()
Application.DataEntryMode = False
End Sub

here's the kb article

http://support.microsoft.com/default.aspx?scid=kb;en-us;213509

 

[Norman Jones]

Hi Escelinen,

See the EnableCancelKey property in VBA help.

For example:

Application.EnableCancelKey = xlDisabled