Code to OK DeleteSheet automatically
 

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?
--
Mickey

Code to OK DeleteSheet automatically
 

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

Hope this helps,

Hutch

"Mikey" wrote:

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?
--
Mickey

Code to OK DeleteSheet automatically
 

Works perfectly. Thanks for the time.
--
Mickey


"Tom Hutchins" wrote:

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

Hope this helps,

Hutch

"Mikey" wrote:

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?
--
Mickey