View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Singh Singh is offline
external usenet poster
 
Posts: 28
Default Removing confirmation POP from excel

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/