Turn off confirmation messages via VBA
 

In xl2000 and later, I believe

xlApp.DisplayAlerts = False
' delete the sheet
xlApp.DisplayAlerts = True

should work.

In earlier versions, I believe you had to put code in the workbook and
execute it to make the setting changes.

--
Regards,
Tom Ogilvy

"LB" wrote in message
...
I have an Access program that I built to manipulate an Excel workbook.
One
of the things I need to do is supress the confimation messages when I
delete
a worksheet via the code. I know I can supress these messages in Access,
but
I'm not sure how to accomplish that in Excel. Any suggestions?