Deleting Sheet without message box
 

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

Deleting Sheet without message box
 

application.displayalerts = false
worksheets("sheet99").delete
application.displayalerts = true

"Mr. T" wrote:

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

--

Dave Peterson

Deleting Sheet without message box
 

Application.DisplayAlerts = False
Sheets("Whatever").Delete
Application.DisplayAlerts = True

"Mr. T" wrote in message
s.com...
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