I am having the same/similar problem. I have a 'temporary' sheet that
I delete and re-load but do not want to see the caution/warning
message verifying the deletion. Here is the code I am using.

Sub RawData_Reset()

' delete & re-create the worksheet "RawData"
Sheets("RawData").Select
ActiveWindow.SelectedSheets.Delete

Sheets("DataBase").Select
ActiveWorkbook.Worksheets.Add.Name = "RawData"

End Sub