In a macro I have, I create a new worksheet to do some work in and then
later in the macro, I delete the worksheet since it is no longer needed.
(There is another worksheet in this workbook that is always there when this
macro runs) When the macro sends the command to delete the worksheet, a
msgbox pops up telling me that there may be data in the worksheet I'm
deleting and am I sure that I want to delete it. I click on the "Delete"
button and the macro continues on its merry way.

How can I either get rid of the msgbox appearing, or put something in the
macro that will automatically select "Delete" on the msgbox so that there is
no interaction from the user required for the macro to finish running?

-Brian