Disabling MsgBox messages while running Call "Macro" function

[marimar02]

Hello,

I'm running several macros by using the Call "Macro Name" function. When I do, all Message Boxes that are written in those macros pop up and I have to click "Ok" each time to go to the next macro. How can I disable these.

Application.DisplayAlerts = False is not the code i'm looking for as I'm not looking to disable system messages but only those that are programmed into the macro.

Thank you...

 

[venkat1926]

keep cursor at the first line of the macro
hit edit-replace(control+H)

against "find what" type
msgbox
against "replace"
'msgbox
(single apostrophe in the beginning)
and click "replace all"

 

[marimar02]

Thanks for the reply venkat. I'm only looking to disable this when I run the Call macros. I still want the messages to pop up when running macros individually.

 

[mikerickson]

A Public boolean variable, noMessageBoxes, could be set to True before calling the subs and set to False afterwards.

 

[marimar02]

Hmmm, that looked promising but didn't stop it

I set it as

public noMsgBox as Boolean
 
private sub CallAll()
 
noMsgBox = True
 
Call Macro1 'an example
Call Macro2
 
noMsgBox = False

Should I spell it out "noMessageBoxes" or what else am I doing wrong? All macro ran as normal and all messages still appeared.

Thanks for your help...

 

[mikerickson]

You also need to alter Macro1 (and Macro2)
Note the second If block that returns the default from a multi-button MsgBox.

Sub Macro1()
   '...
   If Not noMsgBox Then
      MsgBox "simple Message"
   End If

   '...

   If Not noMsgBox Then
      userResponse = Msgbox("Yes or No", vbYesNo)
   Else
      userRespose = vbYes
   End If

   '...
End Sub

 

[Rick Rothstein]

You have to change each of the macros you are calling to have them look at the global variable and react if necessary. In each macro, where you now have this kind of line of code...

MsgBox "Something"

you will need to change it to this...

If Not noMsgBox Then MsgBox "Something"

where the Not is required because you are setting noMsgBox to True when you want the MessageBox skipped.

 

[marimar02]

That worked beautifully... thank you.