Application.WorkbookOnClose

This event is called when a workbook is closed.

Syntax Parameters Return Value
Event Application.WorkbookOnClose( _
    Workbook As Workbook)
Workbook [in]

Type: Workbook

-