Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Closing workbooks w/o closing Excel | Excel Discussion (Misc queries) | |||
Excel 2007 - Links are not completely displayed | Links and Linking in Excel | |||
Completely Exit Excel Macro | Excel Discussion (Misc queries) | |||
Excel not completely closing down | Excel Discussion (Misc queries) | |||
my files won't load completely in excel | Excel Discussion (Misc queries) |