Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Distinguishing what is causing close
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Distinguishing what is causing close
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Distinguishing what is causing close
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Distinguishing what is causing close
Hi NG,
if there is no solution, please state that there is none. That could help stopping from further seaching. Thanks Peter "Peter Ostermann" schrieb im Newsbeitrag ... 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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Distinguishing what is causing close
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
In 2007 I am having difficulty distinguishing highlighted areas | Excel Discussion (Misc queries) | |||
distinguishing filenames | Excel Programming | |||
~~~ Distinguishing Normal; X1.5 and X2 Hours throughout the week by what day and time they are worked ~~~ | Excel Programming | |||
distinguishing formula cells | Excel Discussion (Misc queries) | |||
Distinguishing cell formula from value. | Excel Programming |