View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bernie Deitrick Bernie Deitrick is offline
external usenet poster
 
Posts: 5,441
Default How to inhibit non-interactive MsgBox display

Denis,

You need to write your code to not show it if the macro is run by other code - to do so, you could
pass it a parameter

Sub MacroA(ShowMsg As Boolean)

If ShowMsg Then Msgbox "Hello there"



Then call it like

MacroA False

HTH,
Bernie
MS Excel MVP


"Denis" wrote in message
...
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