Open new workbook(s) when userform and excel are minimized

[Guest]

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

 

[NickHK]

Arjan,
Are you hiding Excel or the window of the workbook ?

NickHK

 

[Guest]

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]

Arjan,
But your code shows the app visible. What is minimised and/or hidden after ?
Otherwise you workbooks.open would be normal.

NickHK

 

[Guest]

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]

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