Distinguishing what is causing close

[Peter Ostermann]

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

 

[Franz Erhart]

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

 

[Norman Jones]

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.

 

[Peter Ostermann]

Hi, Norman,

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.

you describe exactly what I seek. I direct my question to the Microsoft
MVPs. May be one of you people have the info?
Thanks for any answer.

Regards
Peter

 

[Peter Ostermann]

Hi NG,

if there is no solution, please state that there is none. That could help
stopping from further seaching.

Thanks
Peter

 

[Dave Peterson]

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