Application.DocumentBeforeClose Event (Word)

Published: July 16, 2012

Occurs immediately before any open document closes.

Private Sub expression _DocumentBeforeClose(ByVal Doc As Document, Cancel As Boolean)

expression A variable that represents an Application object declared with events in a class module.

Parameters

Name

Required/Optional

Data Type

Description

Doc

Required

Document

The document that's being closed.

Cancel

Required

Boolean

False when the event occurs. If the event procedure sets this argument to True, the document doesn't close when the procedure is finished.

For more information about using events with the Application object, see Using Events with the Application Object.

This example prompts the user for a yes or no response before closing any document. This code must be placed in a class module, and an instance of the class must be correctly initialized to see this example work; see Using Events with the Application Object for directions on how to accomplish this.

Public WithEvents appWord as Word.Application 
 
Private Sub appWord_DocumentBeforeClose _ 
        (ByVal Doc As Document, _ 
        Cancel As Boolean) 
 
    Dim intResponse As Integer 
 
    intResponse = MsgBox("Do you really " _ 
        & "want to close the document?", _ 
        vbYesNo) 
 
    If intResponse = vbNo Then Cancel = True 
End Sub

Community Additions

ADD
Show:
© 2014 Microsoft