EnableCancelKey Property

Returns or sets how CTRL+BREAK is handled when a macro is running. Read/write Long.

PjEnableCancelKey

Example

This example shows how you can use the EnableCancelKey property to set up a custom cancellation handler.

Sub CancelOperation()
    Dim X As Long
    
    On Error GoTo handleCancel
    
    Application.EnableCancelKey = pjErrorHandler
    MsgBox "This may take a long time; press CTRL+BREAK to cancel."
    
    For X = 1 To 300000000
        ' Do something here.
    Next X

handleCancel:
    If Err = 18 Then
        MsgBox "Operation cancelled"
    End If

End Sub

Applies to | Application Object