View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Cush Cush is offline
external usenet poster
 
Posts: 126
Default Application.quit

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?