Removing confirmation POP from excel
 

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/