You realise that that shuts down all of Excel, not just a workbook?check outApplication.DisplayAlerts = Falseand the Saved property, eg.:ActiveWorkbook.Saved = True