Closing Excel Completely
 

David

you need Application.Quit on the end

Regards

Trevor


"David W" wrote in message
...
How do I get excel to close all the way out
I got this code to almost to do it but it don't

Private Sub CommandButton1_Click()
MsgBox "Please Call In"
ActiveWorkbook.Save
ActiveWorkbook.Close
End Sub

Closing Excel Completely
 

This:


Application.DisplayAlerts = False

Application.Quit

Application.DisplayAlerts = True


application false will not display any box asking you close

true will restore it.



Cesar



"Trevor Shuttleworth" wrote in message
...
David

you need Application.Quit on the end

Regards

Trevor


"David W" wrote in message
...
How do I get excel to close all the way out
I got this code to almost to do it but it don't

Private Sub CommandButton1_Click()
MsgBox "Please Call In"
ActiveWorkbook.Save
ActiveWorkbook.Close
End Sub