changing back to excel after starting (shell) program from Macro/VB

Posted by Jason on January 11, 2002 8:42 AM

I have a macro in Excel which starts a program. The macro works fine, but, I need to switch back to my Excel worksheet after it starts automatically instead of having the user Alt-Tab back to Excel.

How do I accomplish this????

Posted by Jason on January 11, 2002 11:19 AM

I have tried using the VBhide, and VBnormalnofocus....ect....with no luck, anyone have any Idea?

Posted by Joe Was on January 11, 2002 3:00 PM

When you call your Shell set the Windowstyle to 4, vbNormalNoFocus

Hope this helps. JSW