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