Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Application.Visible = False
Hi all,
I hope that I can get help with this one. I have a workbook with 'Application.Visible = False' in the 'Workbook open' event, as well as 'Userform1.show'. The relevant Desktop shortcut is set up for the application to run 'Minimized' and to start in "C:\Program Files\Microsoft Office\OFFICE11". In this manner, when the shortcut is Dbl clicked, the userform appears with no visible evidence of Excel having been started. The application.visible attribute is reset in the 'workbook close' event with :"Application visible = true. All of this works extremely well, however wilst previously opened workbooks remain open and visible when I start this workbook, while the workbook is opened I an unable to start any other excel workbook via their shortcuts. I can however start a new instance of Excel then browse to the workbook to open it. MY QUESTION: How do I allow users to start any of their Excel workbooks via their shortcuts while my application is running and the userform showing? Any help will be appreciated |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Application.Visible = False
Let's say we have two workbooks, the first sets Application.Visible to FALSE
and fires off the second workbook (SHELL command or other method). The second workbook would just set Visible back to TRUE and immediately quit. Any subsequent instance of Excel should be Visible. -- Gary's Student "SimonB" wrote: Hi all, I hope that I can get help with this one. I have a workbook with 'Application.Visible = False' in the 'Workbook open' event, as well as 'Userform1.show'. The relevant Desktop shortcut is set up for the application to run 'Minimized' and to start in "C:\Program Files\Microsoft Office\OFFICE11". In this manner, when the shortcut is Dbl clicked, the userform appears with no visible evidence of Excel having been started. The application.visible attribute is reset in the 'workbook close' event with :"Application visible = true. All of this works extremely well, however wilst previously opened workbooks remain open and visible when I start this workbook, while the workbook is opened I an unable to start any other excel workbook via their shortcuts. I can however start a new instance of Excel then browse to the workbook to open it. MY QUESTION: How do I allow users to start any of their Excel workbooks via their shortcuts while my application is running and the userform showing? Any help will be appreciated |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need some comments on my Utility_Move class module. | Excel Worksheet Functions | |||
Stop renaming or moving sheet tabs | Excel Discussion (Misc queries) | |||
Inconsistent Macro Behavior | Excel Discussion (Misc queries) | |||
Grouped Sheets and Formating | Excel Discussion (Misc queries) | |||
Grand Totals @ Same Place | Excel Worksheet Functions |