View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
T.c.Goosen1977[_49_] T.c.Goosen1977[_49_] is offline
external usenet poster
 
Posts: 1
Default Closing Excel Program correctly?


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.c.Goosen197
-----------------------------------------------------------------------
T.c.Goosen1977's Profile: http://www.excelforum.com/member.php...fo&userid=3589
View this thread: http://www.excelforum.com/showthread.php?threadid=55923