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
|