Hi Franz,

2. Open "DieseArbeitsmappe" - for german users, for others the name is
different

I think that you are referring to the workbook's
ThisWorkbook module.

However, I think that Peter's question seeks
a method to differentiate the closure of a
workbook (e.g. ActiveWorkbook.Close)
from a closure caused by terminating the Excel
session.



---
Regards.
Norman


"Franz Erhart" <Franz wrote in message
...
1. Open VBA, means of Alt-F11
2. Open "DieseArbeitsmappe" - for german users, for others the name is
different
3. Select from dropdown menu object "workbook"
4. Select from dropdown menu prozedure "BeforeClose"
5. Enter your code to "Workbook_BeforeClose" as you wish

"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