View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Trevor Shuttleworth Trevor Shuttleworth is offline
external usenet poster
 
Posts: 1,089
Default 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?