Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I recently added to the Workbook_Before_Close procedure the following code ---
---------- ---------- ThisWorkbook.Save Application.Quit Now, when I open Excel, I get an error msg: PERSONAL.XLS is locked for editing...........with the options to 1 Open as Read Only 2 Notify Me 3 Cancel If I Open the file (or any Excel file) I get another Error Msg ----"The instruction at 0x3005c5eb" referenced memory at "0x00000018". The memory could not be written." The OK button then closes Excel and the Cancel button opens Visual Basic with code in C++ ---------------------------- How do I regain access to the Excel application and why does the code I used cause this? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Application.quit | Excel Programming | |||
Application.Quit | Excel Programming | |||
difference application.quit & application.close | Excel Programming | |||
macro to close excel application other than application.quit | Excel Programming | |||
application.quit will not shut off application | Excel Programming |