You'd probably need a Windows API call. Have a look at http://www.everythingaccess.com/tuto...the-foreground and see if it helps.
You'll likely end up with a combination of both this and P45cal's suggestions if you want something specific showing within excel when it becomes the foreground window..