Code to OK DeleteSheet automatically

[Mikey]

I have DeleteSheet code at the end of my macro and the box always pops asking
if I want to Delete the Sheet. What is code to make it automatically close
or = True?

 

[Tom Hutchins]

Put Application.DisplayAlerts = False
before your DeleteSheet code and
Application.DisplayAlerts = True
after it.

Hope this helps,

Hutch

 

[Mikey]

Works perfectly. Thanks for the time.