You should always post YOUR macro for comments. Try this
Sub CLOSE_ALL()
Application.ScreenUpdating = False
Application.DisplayAlerts = False
For Each w In Application.Workbooks
If w.Name < ThisWorkbook.Name Then
w.Save
w.Close
End If
Next w
ThisWorkbook.Save
Application.Quit
End Sub
--
Don Guillett
SalesAid Software
"OlieH" wrote in message
...
Thanks for any help. I am running a macro that saves all workbooks and
then
does application.quit. Excel opens and closes the VisualBasic window.
Since
others will be using this macro, I wish to elimanate this opening/closing.
Thanks for the hlep.