Thread: deleting sheet: how to omit warning
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Jim Rech Jim Rech is offline
external usenet poster
  
Posts: 2,718
Default deleting sheet: how to omit warning
Use Application.DisplayAlerts = False

This will block all alerts until the macro ends so you may want to set it to
True after the delete.

--
Jim Rech
Excel MVP


Reply With QuoteReply With Quote