ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Closing Excel Completely (https://www.excelbanter.com/excel-programming/271355-closing-excel-completely.html)

Phil Perry[_2_]

Closing Excel Completely
 
Sub SAVEEXIT()
Application.ActiveWorkbook.Save
Application.Quit



End Sub

Note this procedure doesn't give the user the option to
save..it just does it.

-----Original 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


.



All times are GMT +1. The time now is 03:35 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com