| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open new workbook(s) when userform and excel are minimized
Hi all,
I have created an excel workbook (i.e. called A) with a userform. When opened, the workbook is set to be not visible and the userform is set to be visible. This all works fine, however when I try to open a new workbook I can't.. It looks like the new workbook is set to be invisible too.. So, how can I to open new visible workbooks when the userform of workbook (A) is minimized and workbook (A) is not visible? thnx!! Arjan Bregman |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Open new workbook(s) when userform and excel are minimized
Arjan,
Are you hiding Excel or the window of the workbook ? NickHK "Arjan" wrote in message ... Hi all, I have created an excel workbook (i.e. called A) with a userform. When opened, the workbook is set to be not visible and the userform is set to be visible. This all works fine, however when I try to open a new workbook I can't.. It looks like the new workbook is set to be invisible too.. So, how can I to open new visible workbooks when the userform of workbook (A) is minimized and workbook (A) is not visible? thnx!! Arjan Bregman |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Open new workbook(s) when userform and excel are minimized
Nick,
this is the code which is used during the workbook open event : _________ application.visible = false userform.show application.visible = true ___________ Arjan -- Arjan Bregman ***** the knowledge is always there, maybe hidden, but it is there.. ***** "NickHK" wrote: Arjan, Are you hiding Excel or the window of the workbook ? NickHK "Arjan" wrote in message ... Hi all, I have created an excel workbook (i.e. called A) with a userform. When opened, the workbook is set to be not visible and the userform is set to be visible. This all works fine, however when I try to open a new workbook I can't.. It looks like the new workbook is set to be invisible too.. So, how can I to open new visible workbooks when the userform of workbook (A) is minimized and workbook (A) is not visible? thnx!! Arjan Bregman |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Open new workbook(s) when userform and excel are minimized
Arjan,
But your code shows the app visible. What is minimised and/or hidden after ? Otherwise you workbooks.open would be normal. NickHK "Arjan" wrote in message ... Nick, this is the code which is used during the workbook open event : _________ application.visible = false userform.show application.visible = true ___________ Arjan -- Arjan Bregman ***** the knowledge is always there, maybe hidden, but it is there.. ***** "NickHK" wrote: Arjan, Are you hiding Excel or the window of the workbook ? NickHK "Arjan" wrote in message ... Hi all, I have created an excel workbook (i.e. called A) with a userform. When opened, the workbook is set to be not visible and the userform is set to be visible. This all works fine, however when I try to open a new workbook I can't.. It looks like the new workbook is set to be invisible too.. So, how can I to open new visible workbooks when the userform of workbook (A) is minimized and workbook (A) is not visible? thnx!! Arjan Bregman |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Open new workbook(s) when userform and excel are minimized
Nick,
Sorry, for my mistake.. this is the correct code: ______________ Sub Auto_Open() Application.Visible = False UserForm.Show End Sub ______________ The only visible part of the app is the userform. any idea? -- Arjan Bregman ***** the knowledge is always there, maybe hidden, but it is there.. ***** "NickHK" wrote: Arjan, But your code shows the app visible. What is minimised and/or hidden after ? Otherwise you workbooks.open would be normal. NickHK "Arjan" wrote in message ... Nick, this is the code which is used during the workbook open event : _________ application.visible = false userform.show application.visible = true ___________ Arjan -- Arjan Bregman ***** the knowledge is always there, maybe hidden, but it is there.. ***** "NickHK" wrote: Arjan, Are you hiding Excel or the window of the workbook ? NickHK "Arjan" wrote in message ... Hi all, I have created an excel workbook (i.e. called A) with a userform. When opened, the workbook is set to be not visible and the userform is set to be visible. This all works fine, however when I try to open a new workbook I can't.. It looks like the new workbook is set to be invisible too.. So, how can I to open new visible workbooks when the userform of workbook (A) is minimized and workbook (A) is not visible? thnx!! Arjan Bregman |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Open new workbook(s) when userform and excel are minimized
Arjan,
Well yes, if Excel is not visible, how can a workbook contained in it be visible ? You would have to make the Application visible also. NickHK "Arjan" wrote in message ... Nick, Sorry, for my mistake.. this is the correct code: ______________ Sub Auto_Open() Application.Visible = False UserForm.Show End Sub ______________ The only visible part of the app is the userform. any idea? -- Arjan Bregman ***** the knowledge is always there, maybe hidden, but it is there.. ***** "NickHK" wrote: Arjan, But your code shows the app visible. What is minimised and/or hidden after ? Otherwise you workbooks.open would be normal. NickHK "Arjan" wrote in message ... Nick, this is the code which is used during the workbook open event : _________ application.visible = false userform.show application.visible = true ___________ Arjan -- Arjan Bregman ***** the knowledge is always there, maybe hidden, but it is there.. ***** "NickHK" wrote: Arjan, Are you hiding Excel or the window of the workbook ? NickHK "Arjan" wrote in message ... Hi all, I have created an excel workbook (i.e. called A) with a userform. When opened, the workbook is set to be not visible and the userform is set to be visible. This all works fine, however when I try to open a new workbook I can't.. It looks like the new workbook is set to be invisible too.. So, how can I to open new visible workbooks when the userform of workbook (A) is minimized and workbook (A) is not visible? thnx!! Arjan Bregman |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Workbook Opens Minimized | Excel Discussion (Misc queries) | |||
| Excel does not open a file until it is minimized - how to repair? | Excel Discussion (Misc queries) | |||
| showing userform with excel minimized | Excel Programming | |||
| open Userform in Another workbook | Excel Programming | |||
| Excel not taking the minimized bar to open next excel file | Excel Discussion (Misc queries) | |||
Hybrid Mode
