Closing Excel Program correctly?

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
 
T

tony h

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

Top