LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel program remains open after closing file RPC Excel Discussion (Misc queries) 9 February 7th 08 07:59 PM
How can I exit a workbook in Excel without closing the program? cosborn Excel Discussion (Misc queries) 1 September 21st 06 09:19 PM
Saving and Closing multiple files and Excel program Roger[_20_] Excel Programming 4 July 19th 05 03:28 AM
Problems closing Excel correctly by code Filips Benoit Excel Programming 2 June 29th 05 01:37 PM
Need program to ask me to save changes when closing yar[_2_] Excel Programming 1 April 22nd 04 08:08 PM


All times are GMT +1. The time now is 06:27 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"