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" wrote in message ...
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