View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Delete worksheet without confirmation

application.DisplayAlerts = False
Sheets("MySheet").Delete
application.DisplayAlerts = True

--
Regards,
Tom Ogilvy

"Ivan" wrote in message
...
Dear all,

I am using a macro to delete a worksheet of a workbook:

Sheets("mySheet").Select
ActiveWindow.SelectedSheets.Delete

However, it prompts me a dialog box for confirmation everytime. How to

skip
this so that the sheet can be delete right away??
Thanks.

Ivan