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

Once you close the workbook, the macro stops working, so the Quit command is
not even executed.
--
Gary''s Student - gsnu200809


"BillCPA" wrote:

> 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