Supress "delete sheets" warning
 

Hi

Use this

Sub test()
Application.DisplayAlerts = False
ActiveSheet.Delete
Application.DisplayAlerts = True
End Sub



--
Regards Ron de Bruin
http://www.rondebruin.nl


"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?