Minimizing application from VBA
 

I've created an application in Excel VBA.
I would like to have Auto_Open(), plus a module if required, minimize the application while leaving the userform open. This essentially hides most evidence that the application in running in Excel VBA. I've tried about a dozen different combinations of code, but haven't yet succeded.

If I do application.windowsize = xlminimize followed by userform.show the form shows in
the minimized application leaving a flashing icon on the application bar.

Ideas would be appreciated.

Minimizing application from VBA
 

Hi

Try Application.visible = False.

To make it visible again, Application.Visible = True.


HTH

Ken


"Steve" wrote in message
...


I've created an application in Excel VBA.
I would like to have Auto_Open(), plus a module if required, minimize the
application while leaving the userform open. This essentially hides most
evidence that the application in running in Excel VBA. I've tried about a
dozen different combinations of code, but haven't yet succeded.

If I do application.windowsize = xlminimize followed by userform.show the
form shows in
the minimized application leaving a flashing icon on the application bar.

Ideas would be appreciated.



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.530 / Virus Database: 325 - Release Date: 22/10/2003

Minimizing application from VBA
 

Thanks Ken

Seems to work fine.