vba-hide workbook and show user form when excel is opened

[happycode]

Hi,
I want to open my userform when my excel is opened and hide the excel behind until the user form closes.
I used
Application. Visible false
Me. Show

It is working but when the excel is opened it shows the excel for a moment and then it is showing userform.
I also tried keeping update links to false. But same thing happened.
How to avoid the workbook shown for a second and show only userform when the excel is opened.
Thank you in advance!

 

[sykes]

I used this:

Private Sub Workbook_Open()
Application.ScreenUpdating = False
Application.Visible = False

UserForm1.Show modeless
Application.ScreenUpdating = True
End Sub

NB test on a COPY of your work first.

The problem is, I don't think the VBA even starts running until the application has started up enough to run the workbook_Open event.
With my setup, the worksheets aren't visible this way, but I do still see the Excel application starting, before the .visible property's set to False, so it's probably no better than that which you've already achieved.
I was hoping that setting screen updating to false might mask the application's startup.

It could be that some of the Top Folk here, will have a better idea...

 

[happycode]

Can't we reduce the load time? And open userform without showing the excel for a second.
Actually firstly it was working fine only later on this is happening. I'm not sure why.