How does msgbox stop the OnTime event?
Ok, but how do I get Excel in a mode that holds OnTime? (How does MsgBox
do
that)
MsgBox does that by being displayed by a macro - the running macro takes
XL out of Ready mode.
If I run a macro which opens a form --similar to a MsgBox-- it will not
prevent the OnTime event from executing; so something more happens in a
MsgBox.
I'm looking for the mechanism that MsgBox uses to change the mode. Just the
fact that MsgBox is called from a macro is not it.
Thanks.
Emile
|