i was searching for a way to delete a worksheet without confirmation prompt in vba and i found this link.
the code is listed here:
Sub DeleteSheet(strSheetName As String)
' deletes a sheet named strSheetName in the active workbook
Application.DisplayAlerts = False
Application.DisplayAlerts = True