Minimizing application from VBA

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

 

[Ken Macksey]

Hi

Try Application.visible = False.

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


HTH

Ken

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.

 

[Guest]

Thanks Ken

Seems to work fine.