Check out Chip Pearson's site:
http://www.cpearson.com/excel/ExcelShutdown.htm


Peter Ostermann wrote:

Hi everyone,

I like to use the "Workbook_BeforeClose" event to program different actions
whether the workbook or the Excel application is beeing closed. Any ideas
how the cause of close can be realized? Thanks in advance for hints.

Peter Ostermann

--

Dave Peterson