delete sheet

[nIGEL bENNETT]

How can I code it to delete a sheet without the warnings

Thanks

 

[Nick Hodge]

Nigel

Sub QuietDelete
With Application
.DisplayAlerts = False
Worksheets("Sheet1").Delete
.DisplayAlerts = True
End With
End Sub

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)