Disable MsgBox when closing workbooks

[Waynest]

I've got a few routines which generate excel spreadsheets using OLEDB. Does anyone know how to stop Excel prompting to see if you are sure you want to close stuff? I cant make everything as automated as I would like because the poxy MsgBoxes keep popping up e.g. the following results in an undesired MsgBox

Sheets("Sheet2&quot.Select
ActiveWindow.SelectedSheets.Delete

Alternatively, is there a way to specify a default reply of yes?

 

[zorancep]

before ActiveWindow.SelectedSheets.Delete use Application.DisplayAlerts = False

I hope it will do
bye