I like to use this

Sub CLOSE_ALL()
Application.ScreenUpdating = False
Application.DisplayAlerts = False
For Each w In Workbooks
w.Save
Next
Application.Quit
End Sub


--
Don Guillett
SalesAid Software

"Frustrated Excel User" <Frustrated Excel
wrote in message ...
In Word the application is not closed until all documents are closed.
However
when you close Excel, it closes all documents. This difference has caused
me
to lose unsaved sheets because I keep expecting Excel to behave the same
as
Word.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.


http://www.microsoft.com/office/comm...lic.excel.misc