View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default 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?