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

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
>
>
>

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 (E-Mail Removed)> wrote in message
news8299E20-1D49-4761-B332-(E-Mail Removed)...
> 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
>>
>>
>>

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

Hi NG,

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

Thanks
Peter


"Peter Ostermann" <peter-(E-Mail Removed)> schrieb im Newsbeitrag
news:g2r1co$2e8$03$(E-Mail Removed)...
> 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
>

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