Hi Singh,

It is working for me too......... Perfect.

Actually, there is a potentially significant typo!

The second instance of

.DisplayAlerts = False

should reinstate alerts.

Therefore, replace the code with:

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

Normally, Excel will automatically reset
the property to true when the code finishes,
but there could be repercussions with cross
processing code.

Apologies for the typo!


---
Regards.
Norman