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

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

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

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

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

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