Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Minimizing application from VBA
Thanks Ken
Seems to work fine. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Minimizing Rows of with similar data | New Users to Excel | |||
Minimizing number of commands | Excel Discussion (Misc queries) | |||
minimizing problem | Excel Discussion (Misc queries) | |||
Minimizing a user form | Excel Programming | |||
Minimizing a Form | Excel Programming |