Turn off confirmation messages via VBA
In Excel:
Application.DisplayAlerts = False
' your code
Application.DisplayAlerts = True
Regards
Trevor
"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?
|