"Ken" wrote in message
...
We have a macro in which we are deleting a worksheet. When
the code gets to that point, the user gets a warning
message about permanently deleting the worksheet.

How do we turn off that warning in the macro?

Application.DisplayAlerts = False

Do we need to turn the warnings back on before we close
the macro?

Application.DisplayAlerts = True

Keith