Minimizing application from VBA

S

Steve

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

Ken Macksey

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Failure to load icon causes UserForm to minimize to bogus object inworksheet area. 0
How to stop Stephen Bullen's CFormChanger from minimizing as an MDItitle bar? 7
VBA code won't run, even with Macro Security set to Enable All Macors 9
VBA - need to minimize Excel from UserForm 2
Excel Application to MS Access Application 2
Set Focus on Form & Minimize Word 3
VBA need to minimize Excel from UserForm 1
Alternatives to Excel VBA (Query Tables returning more than a million rows) 2

Top