i ran into this problem recently while trying to make excel play a midi
file - the windows media player would open & take the focus, and then
not allow a msgbox to show.
after much searching & reading previous postings in the newsgroup, it
is my understanding that you can't force windows to put the focus on an
inactive application........ it's not an excel issue, it's a windows
issue.
susan


Stefan Mueller wrote:
I start a VBA macro in Excel. This macro is running several minutes.
During that time I open e.g. the Internet Explorer.
When the VBA macro has finished it shows a MsgBox. Unfortunately I
don't see this message box because Excel is not the avtive application
at that time (the message box is behind the Internet Explorer).

How can I make Excel the active application just after the VBA macro
has finished so that I see the message box?
Stefan