Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel program remains open after closing file | Excel Discussion (Misc queries) | |||
How can I exit a workbook in Excel without closing the program? | Excel Discussion (Misc queries) | |||
Saving and Closing multiple files and Excel program | Excel Programming | |||
Problems closing Excel correctly by code | Excel Programming | |||
Need program to ask me to save changes when closing | Excel Programming |