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