View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Denis[_4_] Denis[_4_] is offline
external usenet poster
 
Posts: 38
Default How to inhibit non-interactive MsgBox display

I'm using a VBScript to start an excel macro (opening a workbook that
automatically runs via Workbook_Open()). This macro opens another
workbook and runs a macro in it, call it macro A. Macro A generates
an informational message with a MsgBox display. Since this is running
as a non-interactive session, I need to inhibit the display of this
MsgBox. I've tried DisplayAlerts=False and that doesn't do it. How
can I inhibit this MsgBox?

Denis