Supress "delete sheets" warning
 

Hi ConEddie,

Application.DisplayAlerts = False
Sheets("Sheet2").Select
ActiveWindow.SelectedSheets.Delete
Application.DisplayAlerts = True

Regards,
Hari
India

"ConEddie" wrote in message
...
Does anyone know how to supress the "The slected sheet(s) will be
permanently
delted" warning when deleting a worksheet from a wookbook?
I would like to do it in the VBA code but if that's not possible, how
about
setting some workbook options?