ExcelBanter - Removing confirmation POP from excel

Hi Joel
Can we do the same without giving the sheet name?

"Joel" wrote:

Application.DisplayAlerts = False

Worksheets("Sheet3").Delete
Application.DisplayAlerts = True

"singh" wrote:

Hi All

In one of my macro i have provided code for deleting a particular sheet.
In between a pop up appears asking for confirmation for delete or cancel the
sheet.
Is there any way we can remove this prompt?

I tried Application.DisplayAlerts = False. this thing is not proper for this.

Thanks in Advance/