Application.SpreadsheetOnClose

This event is called when a spreadsheet is closed.

Syntax Parameters Return Value
Event Application.SpreadsheetOnClose( _
    Spreadsheet As Spreadsheet)
Spreadsheet [in]

Type: Spreadsheet

-