Application.Quit

  • Thread starter Thread starter BillCPA
  • Start date Start date
B

BillCPA

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?
 
Once you close the workbook, the macro stops working, so the Quit command is
not even executed.
 
Back
Top