Delete method
 

Does anyone know how to stop the delete method from prompting the user when
you use it to delete a chart sheet. I'm using it to delete multiple sheets
and it get annoying to have to press enter repeatedly

Delete method
 

Hi,
Try
Application.DisplayAlerts =False

Regards,
sebastien

"chessley" wrote:

Does anyone know how to stop the delete method from prompting the user when
you use it to delete a chart sheet. I'm using it to delete multiple sheets
and it get annoying to have to press enter repeatedly

Delete method
 

Chessley,

Sub byebye()
Application.DisplayAlerts = False
ThisWorkbook.Charts("Chart1").Delete
Application.DisplayAlerts = True
End Sub

where "Chart1" is the chart you are deleting, with this method always make
sure to turn Alerts Back on using Application.DisplayAlerts = True


"chessley" wrote:

Does anyone know how to stop the delete method from prompting the user when
you use it to delete a chart sheet. I'm using it to delete multiple sheets
and it get annoying to have to press enter repeatedly