View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Closing Excel Completely

Private Sub CommandButton1_Click()
MsgBox "Please Call In"
ActiveWorkbook.Save
Application.Quit

End Sub

"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