Opening Userform only without flashing Excel Window

Question

I know the method as Application.Visible = False and Application.Screenupdating = False

When opening the file, I want the user to see only the userform.

The thing is: with these two commands above, Excel appears for 1 second. Is it possible to do it without Excel blinking like this?

Thanks in advance.

Answer 1

You may try to open the excel file not with excel itself to avoid the splash. Try script to open excel file, then form will open without splash :

'save this in a text file, change extension as .vbs

Set objExcel = CreateObject("Excel.Application")
objExcel.Visible = false
Set objWorkbook = objExcel.Workbooks.Open("C:\Users\USER\Desktop\yourfile.xlsm") 

'this will open excel as invisible, so to close excel you have to insert some button inside userform or something like ThisWorkbook.Close savechanges = False or Application.Quit

'and of course assuming that your form is in the workbook_open in your project like

Private Sub Workbook_Open()
'ActiveWindow.WindowState = xlMinimized
'Application.Visible = False
Application.ScreenUpdating = False
Application.EnableEvents = False
'Application.EnableAnimations = False
UserForm1.Show
End Sub