Hello,
I have a workbook that opens a userform as (vbModeless) on open and hides the window.
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
I have a workbook that opens a userform as (vbModeless) on open and hides the window.
Code:
Private Sub Workbook_open()
Windows("Test").Visible = False
Welcome.Show (vbModeless)
End Sub
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