Minimizing application from VBA

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Hi

Try Application.visible = False.

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


HTH

Ken


Steve said:
I've created an application in Excel VBA.
I would like to have Auto_Open(), plus a module if required, minimize the
Click to expand...
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.
 
Back
Top