I have a workbook that opens a userform as (vbModeless) on open and hides the window.
Private Sub Workbook_open()
Windows("Test").Visible = False
Welcome.Show (vbModeless)
End Sub
The problem i am encountering is that this works only when there are other workbooks opened. If i open it as single workbook it also displays empty Excel application. How can i avoid this and have only userform visible no matter if i have other workbooks open or not?

My second issue is how to make the userform always open in center of screen when i have double monitors. StartUpPosition is default (1-CenterOwner), but form does not always appear centered.

Thanks in advance