Worksheet.Delete without a prompt (Excel 200/2002/2003)

[StuartR]

I have a VBA routine that creates a temporary worksheet for storing some information. (shtTemp = wbkWorkbook.Worksheets.Add)
When I finish my routine I need to delete the temporary worksheet, but this creates a user visible "are you sure" dialog box

I guess I could just set my sheet to be xlVeryHidden and re-use it next time, but is there a way to delete it without the user seeing a prompt?

StuartR

[HansV]

Put <code>Application.DisplayAlerts = False</code> before, and <code>Application.DisplayAlerts = True</code> after the line that deletes the worksheet.

[StuartR]

Thanks, why didn't I think of that.

I guess I will also have to add <code>Application.DisplayAlerts=True</code> to my error handling / exit code, in case the delete fails!

StuartR

[HansV]

Yes, that's what I usually do, just like <code>Application.ScreenUpdating = True</code>.