View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ken Macksey Ken Macksey is offline
external usenet poster
 
Posts: 77
Default 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