Thread: Delete a Sheet without dialog
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike Fogleman Mike Fogleman is offline
external usenet poster
  
Posts: 1,092
Default Delete a Sheet without dialog
Application.DisplayAlerts = False
Sheets("Replace Info").Delete
Application.DisplayAlerts = True

Mike F

"Ken Loomis" wrote in message
...
I am using this to delete a worksheet:

Sheets("Replace Info").Delete

however, that causes a warning dialog box. How can I delete that worksheet
without a dialog box?





Reply With QuoteReply With Quote