| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Window
Hi all,
I'm looking for the API Calls for the excel window to be hidden however I still want the userforms to come up on the screen. If anybody can help me that would be greatly appreciatly. Jason |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel Window
Hi Jason Does this help you Application.Visible = False UserForm1.Show Best N10 "Jason Zischke" wrote in message ... Hi all, I'm looking for the API Calls for the excel window to be hidden however I still want the userforms to come up on the screen. If anybody can help me that would be greatly appreciatly. Jason |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel Window
N10
Thanks That worked perfectly. Jason Zischke "N10" wrote: Hi Jason Does this help you Application.Visible = False UserForm1.Show Best N10 "Jason Zischke" wrote in message ... Hi all, I'm looking for the API Calls for the excel window to be hidden however I still want the userforms to come up on the screen. If anybody can help me that would be greatly appreciatly. Jason |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel Window
Be careful doing this kind of thing. Some potential problems a
In case of a crash your error handler has to bring the application back or the user will loose other spreadsheets they may have been working on. Users will believe that spreadsheets that they had open are gone and they will try to reopen them. This will cause problems as they are already open in the hidden instance. If the user tries to open other spreadsheets they will open in the hidden instance of Excel. The user will open new instances of Excel and then when you re-activate the original instance of Excel they will have two instances which can cuase some difficulties. I am not saying don't do it just be aware of the side effects of hiding the application... -- HTH... Jim Thomlinson "Jason Zischke" wrote: N10 Thanks That worked perfectly. Jason Zischke "N10" wrote: Hi Jason Does this help you Application.Visible = False UserForm1.Show Best N10 "Jason Zischke" wrote in message ... Hi all, I'm looking for the API Calls for the excel window to be hidden however I still want the userforms to come up on the screen. If anybody can help me that would be greatly appreciatly. Jason |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I "re-hook" my worksheet window to my Excel window? | Excel Discussion (Misc queries) | |||
| How can I "re-hook" my worksheet window to my Excel window? | Excel Discussion (Misc queries) | |||
| The window opens in a smaller window not full sized window. | Excel Discussion (Misc queries) | |||
| In Excel - how to delete new window created from window on tool ba | Excel Worksheet Functions | |||
| How do I undo the Excel, Window Menu, New Window command | Excel Discussion (Misc queries) | |||
Hybrid Mode
