Suppress the Excel opening splash screen

[DaveSp]

Good day all.

I had VBA code that displays a userform upon opening Excel (ThisWorkbook) code below.

When I start Excel, the Excel splash screen displays, then the workbook displays momentarily and then minimizes before the userform is displayed.

Is there a way to suppress the display of the Excel splash screen and the initial display of the workbook so that the first and only thing the user sees is the userform?

I've search the forum and see a number of post on splash screens but none that discuss suppressing the opening Excel splash. I'd appreciate any help you all can provide.

Thanks.

Private Sub Workbook_Open()
'   Hide Excel and display the userform
    Application.ScreenUpdating = False
    Application.WindowState = xlMinimized
    Application.Visible = False
    UserForm4.Show Modal
    Call ValidateUser
End Sub

 

[Jaafar Tribak]

What if it is a Macro Enabled File. when I tried this I got an error
"C:\LARL EXTREME CLEANING\TOOLS\LARL MAIN MENU.xlsm" this is the path I put in there

View attachment 33729

It looks from the error screen that you are passing the wrong excel file name because you are putting the string between the html tags.

Replace this :
Set Wb = XlApp.Workbooks.Open("[ B]C:\LARL EXTREME CLEANING\TOOLS\LARL MAIN MENU.xlsm[ /B]")

With this:
Set Wb = XlApp.Workbooks.Open("C:\LARL EXTREME CLEANING\TOOLS\LARL MAIN MENU.xlsm")