Posted by rm on February 01, 2002 4:54 PM
I am using application.quit to close Excel when the workbook is closed by the user (only can close with custom cb button in workbook or with "x" button). The cb button and window close button, but does not work when you terminate the application with the application's close button (the "x" at the top)...when you try to do this, the workbook closes, but Excel does not terminate. How can it be corrected so that using the application close button will terminate Excel?
p.s. thanks to Jack in U.K. for the tip about clearing memory--ran update of workbooks with sub (over 700 & took 3 hours to run!) and did not run out of memory...thanks a lot again!