Deleting Sheet without message box

  • Thread starter Thread starter Mr. T
  • Start date Start date
M

Mr. T

Hello,

I want to delete a worksheet, but upon doing so a message box pops up
informing the user that the sheet will be deleted, giving OK and Cancel
options. How do I suppress this message box? I have screened the application
object for a switch but have not figured out what to do.

Thank you so much for your help!!

Oliver
 
application.displayalerts = false
worksheets("sheet99").delete
application.displayalerts = true
 
Application.DisplayAlerts = False
Sheets("Whatever").Delete
Application.DisplayAlerts = True
 
Back
Top