Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
workbook_beforeClose
For some reason, when closing excel, the code in my workbook_beforeClose
section (Located in "ThisWorkbook") does not run. I have the following situation: A personal.xls file located in my XLStart folder. The file runs the workbook_Open routine when opened. The only worksheet is hidden so that there is no associated worksheet for the user to interact with. Excel opens a separate workbook with the expected number of blank worksheets. I can open, edit, and process other files on which I want to use the macros in my personal.xls. When closing excel by choosing the 'X' in the upper corner, all other applications process properly, however the beforeclose event in my personal.xls file does not get run. I have added a stop command in the code to attempt debugging, and also a breakpoint as so desired, but it stops at neither of these. What is wrong with my logic? There are some commands that I would like to process prior to closing the personal.xls file and would have to come up with some other method if I can not resolve this. V/R, GB |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
workbook_beforeClose
Your observation appears to be correct. The before close event does not seem
to trigger out of the personal.xls workbbok. Very curious. That being said you can use an Auto_close routine that will fire... In a standard code module add the following... Sub Auto_Close() MsgBox "Tada" End Sub That seems to work. -- HTH... Jim Thomlinson "GB" wrote: For some reason, when closing excel, the code in my workbook_beforeClose section (Located in "ThisWorkbook") does not run. I have the following situation: A personal.xls file located in my XLStart folder. The file runs the workbook_Open routine when opened. The only worksheet is hidden so that there is no associated worksheet for the user to interact with. Excel opens a separate workbook with the expected number of blank worksheets. I can open, edit, and process other files on which I want to use the macros in my personal.xls. When closing excel by choosing the 'X' in the upper corner, all other applications process properly, however the beforeclose event in my personal.xls file does not get run. I have added a stop command in the code to attempt debugging, and also a breakpoint as so desired, but it stops at neither of these. What is wrong with my logic? There are some commands that I would like to process prior to closing the personal.xls file and would have to come up with some other method if I can not resolve this. V/R, GB |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
workbook_beforeClose
Thanks, I had done a search for AUTOOPEN and AUTOCLOSE but not Auto_close.
Thank you. It worked when I went ahead and put it in a separate module, and made my Workbook_BeforeClose event Public. (Saved me some time in rewriting, will evaluate the necessity later. "Jim Thomlinson" wrote: Your observation appears to be correct. The before close event does not seem to trigger out of the personal.xls workbbok. Very curious. That being said you can use an Auto_close routine that will fire... In a standard code module add the following... Sub Auto_Close() MsgBox "Tada" End Sub That seems to work. -- HTH... Jim Thomlinson "GB" wrote: For some reason, when closing excel, the code in my workbook_beforeClose section (Located in "ThisWorkbook") does not run. I have the following situation: A personal.xls file located in my XLStart folder. The file runs the workbook_Open routine when opened. The only worksheet is hidden so that there is no associated worksheet for the user to interact with. Excel opens a separate workbook with the expected number of blank worksheets. I can open, edit, and process other files on which I want to use the macros in my personal.xls. When closing excel by choosing the 'X' in the upper corner, all other applications process properly, however the beforeclose event in my personal.xls file does not get run. I have added a stop command in the code to attempt debugging, and also a breakpoint as so desired, but it stops at neither of these. What is wrong with my logic? There are some commands that I would like to process prior to closing the personal.xls file and would have to come up with some other method if I can not resolve this. V/R, GB |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Workbook_BeforeClose | Excel Discussion (Misc queries) | |||
Workbook_BeforeClose | Excel Programming | |||
Workbook_BeforeClose | Excel Programming | |||
Workbook_BeforeClose | Excel Programming | |||
Workbook_BeforeClose | Excel Programming |