Code to OK DeleteSheet automatically

's Computer Specifications

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

's Computer Specifications

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

's Computer Specifications

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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
automatically add country code	george	Microsoft Outlook Contacts	3	15th Sep 2004 12:14 PM
How to get a usercontrol to automatically add code to the initialization code in a form...	Simon Verona	Microsoft VB .NET	21	30th Jun 2004 05:22 PM
how to code for automatically sorting ?	Mebane Faber	Microsoft Excel Programming	2	22nd Jun 2004 04:14 PM
Code to automatically overwrite?	andycharger	Microsoft Excel Programming	2	10th Feb 2004 09:44 AM
Begin code automatically	Dave	Microsoft Access Form Coding	2	3rd Dec 2003 05:31 PM