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