Closing Excel Program correctly?

  • Thread starter Thread starter T.c.Goosen1977
  • Start date Start date
T

T.c.Goosen1977

Im using the following code to quite excel:

Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode A
Integer)
Application.Quit
ActiveWorkbook.Close
End Sub

A standard saving message pops up when i click the "x" on the userform
if I click “yes” it saves the file and quits excel = 100% , if I clic
“no” it does not save the file but it quits excel = 100%, but when
click the cancel button or the "x" it does not unload the standar
excel saving message and resume the userform...it goes into debu
mode?
Thanks
Theun
 
You say it goes into Debug mode. In whick sub routine and at what line
Can you post the associated code
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Quiting Excel program? 3
automation error when closing excel 3
Queryclose 6
Userform close 4
Query Close code question?? 1
Application.Quit in Excel 2007 4
Retain value of userform option button 3
Create a yes no message on a command button on click 0

Back
Top