Msgbox after sheets are deleted

[Phatchef24]

Hi Guys,

I have a macro that deletes a bunch of worksheets when it is run and Excel pops up a msgbox after each sheet asking if I'm sure I want to delete the worksheet. Is there a way to turn this off? Or is there some code that will automatically click the okay button so that the user wont have to?

Thanks!

[davidm]

Insert at the appropriate line:

Application.DisplayAlerts=False

(remember to restore before Exit Sub by setting command to True)

[Phatchef24]

Thanks! I figured it was something simple.