delete method of a worksheet object deletes the worksheet application.displayAlerts to false before deleting a worksheet so that the user is not prompted to confirm the deletion (Message Box with «Microsoft Excel will permantently delete shis sheet. Do you want to continue?»): dim ws as worksheet : set ws = sheets("fooBarBaz")
dim da as boolean : da = application.displayAlerts
application.displayAlerts = false
ws.delete
application.displayAlerts = da