Workbook.BeforeClose

This event is called before the workbook is closed.

Syntax Parameters Return value 
Event Workbook.BeforeClose( _
    ByRef Cancel As Boolean)
 Cancel [in, out]

Type: Boolean

-