I have one macro (macro1) that calls a different macro (macro2). At the end of macro2 a MsgBox displays, which I want to suppress so macro1 can continue. Macro2 is used separately in other cases and so changing it isn't an option.
DisplayAlerts = False seems to be the code I want, but in testing it just doesn't work. So then I tested it with a barebones simple macro (i.e. turn DisplayAlerts off then call a sub that simply displays a MsgBox) and still the msg appears.
When stepping through the macro the tooltip always displays true for DisplayAlerts even immediately after DisplayAlerts = False has passed.
What's the catch here?
DisplayAlerts = False seems to be the code I want, but in testing it just doesn't work. So then I tested it with a barebones simple macro (i.e. turn DisplayAlerts off then call a sub that simply displays a MsgBox) and still the msg appears.
When stepping through the macro the tooltip always displays true for DisplayAlerts even immediately after DisplayAlerts = False has passed.
What's the catch here?