Application.DisplayAlerts = False
;
your code
;
Application.DisplayAlerts = True

Regards

Trevor


"CurtB" wrote in message
...
I have a workbook that creates new worksheets using a template worksheet
and
a data worksheet (kind of like a Word mailmerge). An index worksheet is
also
updated with the names of the created worksheets and hyperlinks to them.
When I want to clear the workbook, I loop through the index worksheet
calling the following macro that deletes the created worksheets. I also
delete entries in the index.

Sub Remove_Worksheet(WorksheetName As String)
Sheets(WorksheetName).Select
ActiveWindow.SelectedSheets.Delete
End Sub

This macro works fine, but a verification message is displayed each time a
worksheet is to be deleted.

Data may exist in the sheet(s) selected for deletion. To permanently
delete
the data, press Delete.

Delete Cancel

I was wondering if there is a command that will prevent this message box
from being displayed and allow the worksheet to be deleted without
requiring
an individual user provided response for each one? Thanks.