Hi Jones

Thanks a bunch
It is working for me too......... Perfect.

"Norman Jones" wrote:

Hi Singh,

The following works for me

'==========
Public Sub aTester()
With Application
.DisplayAlerts = False
ActiveSheet.Delete
.DisplayAlerts = False
End With
End Sub
'<<==========


Why do you say:

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


---
Regards.
Norman


"singh" wrote in message
...
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/