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
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