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/
|