View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Emile van Mierlo Emile van Mierlo is offline
external usenet poster
 
Posts: 11
Default 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