Posted to microsoft.public.excel.programming

BillCPA

external usenet poster

Posts: 101

Application.Quit

I have the following code behind a command button on a user form. The object
is to close the workbook and then quit Excel.

KOMenu.Hide
Application.StatusBar = False
Application.ScreenUpdating = True
ActiveWindow.WindowState = xlMaximized
ActiveWorkbook.Close Savechanges:=False
Application.Quit

It closes the workbook but Excel itself stays open. If I take out the
..Close statement, it quits Excel correctly. Any suggestions on why this
might happening?

--
Bill @ UAMS

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Application.Quit Does not Close the Application	[email protected]	Excel Programming	6	October 8th 09 10:32 PM
difference application.quit & application.close	Pierre via OfficeKB.com[_2_]	Excel Programming	4	November 8th 05 07:55 PM
application.quit	Murat Demir HEKIMOGLU	Excel Programming	1	August 19th 05 09:02 AM
macro to close excel application other than application.quit	mary	Excel Programming	1	September 14th 04 03:43 PM
application.quit will not shut off application	john	Excel Programming	0	January 9th 04 11:29 PM

All times are GMT +1. The time now is 09:31 AM.

About Us

"It's about Microsoft Excel"