How to turn off safety message when deleting a worksheet

[L.Peter]

Dear Group,
How to tell excel not to ask when I delete a worksheet?

TIA

Peter

 

[dave]

Hi Peter

Application.DisplayAlerts = False
Sheet1.Delete
Application.DisplayAlerts = True


***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****

 

[L.Peter]

Thanks Dave, It works
Best Regards

Peter

 

[Sipen Yu]

' To disable the warning
application.DisplayAlerts = False

'To Delete the worksheet
ActiveWindow.SelectedSheets.Delete

'To enable the warning systems back
application.DisplayAlerts = True