Deleting an Excel Worksheet 1

[dace]

Hi-

Is there a way to delete/remove an Excel worksheet without popping up the "are you sure you want to do this" dialog?

Thanks!

 

[brucegn]

Try adding

Application.DisplayAlerts = False

Before the line that is actually deleting the sheet and set it back after.

Application.DisplayAlerts = False
Sheets(1).Delete
Application.DisplayAlerts = True

 

[ilses]

Application.DisplayAlerts = False

Worksheets("Blad2").Delete

Application.DisplayAlerts = True

Best regards,

Ilse

 

[dace]

Thanks, that's exactly what I needed!