VBA Bypass Delete Sheet Warning

[bill_morgan]

Friends,

I have written VBA code that loops through 150 workbooks and performs
various tasks on each workbook. One task I need to perform is deleting one
sheet in each workbook.

Problem is, the Excel Delete Sheet Warning message box appears before each
deletion, which means I need to manually confirm the deletion 150 times. Is
there a VBA way to turn off Excel's delete sheet warning (like there is in
Access)?

Thanks for your help ...

bill morgan

[Jim Thomlinson]

application.displayalerts = false
sheets("Whatever").Delete
application.displayalerts = true
--
HTH...

Jim Thomlinson


"bill_morgan" wrote:

> Friends,
>
> I have written VBA code that loops through 150 workbooks and performs
> various tasks on each workbook. One task I need to perform is deleting one
> sheet in each workbook.
>
> Problem is, the Excel Delete Sheet Warning message box appears before each
> deletion, which means I need to manually confirm the deletion 150 times. Is
> there a VBA way to turn off Excel's delete sheet warning (like there is in
> Access)?
>
> Thanks for your help ...
>
> bill morgan
>
>

[davesexcel]

Sub ..
Application.DisplayAlerts = False
'your code here ...
Application.DisplayAlerts = True
End Sub

[Gary Keramidas]

something like this

Sub delsheet()

Application.DisplayAlerts = False
Worksheets("sheet3").Delete
Application.DisplayAlerts = True
End Sub

--


Gary


"bill_morgan" <[email protected]> wrote in message
news:[email protected]...
> Friends,
>
> I have written VBA code that loops through 150 workbooks and performs
> various tasks on each workbook. One task I need to perform is deleting one
> sheet in each workbook.
>
> Problem is, the Excel Delete Sheet Warning message box appears before each
> deletion, which means I need to manually confirm the deletion 150 times. Is
> there a VBA way to turn off Excel's delete sheet warning (like there is in
> Access)?
>
> Thanks for your help ...
>
> bill morgan
>
>

[Ron de Bruin]

Hi Bill

You can use this

Application.DisplayAlerts = False
'Code
Application.DisplayAlerts = True


--
Regards Ron de Bruin
http://www.rondebruin.nl


"bill_morgan" <[email protected]> wrote in message news:[email protected]...
> Friends,
>
> I have written VBA code that loops through 150 workbooks and performs
> various tasks on each workbook. One task I need to perform is deleting one
> sheet in each workbook.
>
> Problem is, the Excel Delete Sheet Warning message box appears before each
> deletion, which means I need to manually confirm the deletion 150 times. Is
> there a VBA way to turn off Excel's delete sheet warning (like there is in
> Access)?
>
> Thanks for your help ...
>
> bill morgan
>
>

[bill_morgan]

Excellent. Thank you, Jim ...

"Jim Thomlinson" wrote:

> application.displayalerts = false
> sheets("Whatever").Delete
> application.displayalerts = true
> --
> HTH...
>
> Jim Thomlinson
>
>
> "bill_morgan" wrote:
>
> > Friends,
> >
> > I have written VBA code that loops through 150 workbooks and performs
> > various tasks on each workbook. One task I need to perform is deleting one
> > sheet in each workbook.
> >
> > Problem is, the Excel Delete Sheet Warning message box appears before each
> > deletion, which means I need to manually confirm the deletion 150 times. Is
> > there a VBA way to turn off Excel's delete sheet warning (like there is in
> > Access)?
> >
> > Thanks for your help ...
> >
> > bill morgan
> >
> >

[bill_morgan]

So simple! Thanks, Gary ...

"Gary Keramidas" wrote:

> something like this
>
> Sub delsheet()
>
> Application.DisplayAlerts = False
> Worksheets("sheet3").Delete
> Application.DisplayAlerts = True
> End Sub
>
> --
>
>
> Gary
>
>
> "bill_morgan" <[email protected]> wrote in message
> news:[email protected]...
> > Friends,
> >
> > I have written VBA code that loops through 150 workbooks and performs
> > various tasks on each workbook. One task I need to perform is deleting one
> > sheet in each workbook.
> >
> > Problem is, the Excel Delete Sheet Warning message box appears before each
> > deletion, which means I need to manually confirm the deletion 150 times. Is
> > there a VBA way to turn off Excel's delete sheet warning (like there is in
> > Access)?
> >
> > Thanks for your help ...
> >
> > bill morgan
> >
> >
>
>
>

[bill_morgan]

Thanks, Ron. Everybody giving me the same answer, so must be the BEST way ...


"Ron de Bruin" wrote:

> Hi Bill
>
> You can use this
>
> Application.DisplayAlerts = False
> 'Code
> Application.DisplayAlerts = True
>
>
> --
> Regards Ron de Bruin
> http://www.rondebruin.nl
>
>
> "bill_morgan" <[email protected]> wrote in message news:[email protected]...
> > Friends,
> >
> > I have written VBA code that loops through 150 workbooks and performs
> > various tasks on each workbook. One task I need to perform is deleting one
> > sheet in each workbook.
> >
> > Problem is, the Excel Delete Sheet Warning message box appears before each
> > deletion, which means I need to manually confirm the deletion 150 times. Is
> > there a VBA way to turn off Excel's delete sheet warning (like there is in
> > Access)?
> >
> > Thanks for your help ...
> >
> > bill morgan
> >
> >
>
>
>

[bill_morgan]

Thanks, Dave. Glad I asked ... so simple, but would have taken me awhile to
figure out.

"davesexcel" wrote:

>
> Sub ..
> Application.DisplayAlerts = False
> 'your code here ...
> Application.DisplayAlerts = True
> End Sub
>
>
> --
> davesexcel
> ------------------------------------------------------------------------
> davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
> View this thread: http://www.excelforum.com/showthread...hreadid=517423
>
>