Hide parent document window

[jackha18]

I need to use Excel user form with other application. I made the form topmost window using SetWindowPos API function. The problem is that excel document pops-up every time I activate the form.

I can hide Excel using Application.Visible=False but then I can't use other Excel documents.

How can I prevent from parent document window poping-up without hiding the application?

 

[PHV]

Have you tried this ?
Application.WindowState = xlMinimized

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[jackha18]

Too simple to be true !

If you have a child and a parent window, you cannot activate the child without activating the parent. So every time I activate the child (in my case - Excel form) the parent (Excel document window) also got activated.

The only solution I came upon till now is to make Excel window size 50x50 and move behind user form every time the form is moved. In this case since the form is set topmost window it will conceal the Excel window, but then I have to track changes in active document to make Excel normal (not 50x50) size when other document got selected.

I just thought some of the API gurus wlil say their word on it. Is there more elegant way to to solve this?