Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Workbook_BeforeClose | Excel Discussion (Misc queries) | |||
Workbook_BeforeClose | Excel Programming | |||
Workbook_BeforeClose | Excel Programming | |||
Workbook_BeforeClose | Excel Programming | |||
Workbook_BeforeClose | Excel Programming |