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

 

[mole999]

if you can get them to use a dedicated shortcut use the q switch > How to Disable the Splash Screens in Office (Word, Excel, PowerPoint)

 

[DaveSp]

Thanks Mole99. Not sure that will work, as the users will be opening the Excel application by clicking on a short to the file name, not to Excel. But I gave it a try. Adding the /q switch to the excel.exe file does shorten the time the Excel splash in on screen but does not eliminate it. Adding the /q switch to short cut ("U:\Invoice Analysis Files\Working Project\Invoice Analysis V3.xlsm" /q) doesn't work either.

I am really hoping there is a VBA solution to suppressing the splash screen - any other ideas? Also using the code I supplied, any idea why the workbook display monetarily, even though I have the two statements:

Application.WindowState = xlMinimized
Application.Visible = False

 

[mole999]

excel has to load before macro will run, so it has precedence over code (IMHO)

not sure what the construction would look like but suspect if possible

******************excel / q "U:\Invoice Analysis Files\Working Project\Invoice Analysis V3.xlsm"

 

[Jaafar Tribak]

The only workaround I can think of is to have the excel file opened programatically by a script instead of having it opened by the user

How to procedd:

1- Place the excel file in a hidden location (ie: in a hard to find location) on the user's computer
2- Open Notepad and place the following vbscript code in it:

Set xlapp = CreateObject("Excel.Application")
xlapp.Visible = false
Set Wb = XlApp.Workbooks.Open("[B]PUT_YOUR_EXCEL_FILE_FULL_PATH_NA_NAME_HERE[/B]")

3- After writing the correct excel file path in the above script, save the vbscript with the .VBS extension in the same hidden location as that of the excel file
4- Create a shortcut to the VBS file and place it in the user's desktop (You can change the shortcut icon to show the excel icon by right clicking it and choosing Properties/Shortcut tab/Change Icon button)

Now, in order for the user to open the excel file , he/she will have to click on the vbscript shortcut located on the desktop and the latter will take care of opening the excel file without showing the excel splashscreen or the workbook - Just the userform will be on display

 

[daverunt]

Untested

Suppressing the Excel Splash Screen | Bacon Bits

 

[DaveSp]

Thanks Jaafar, I like this and will have to try it and see hoew it work, but unfortunately, for this application, hiding the Excel file on each users computer is not a good option....

 

[DaveSp]

Thanks daverunt. This too is a good option. I tried is and it works for me. Now to see if the headaches of getting the short cut setup and all the users computers is worth it. I may just.

Dave

 

[rammpeth]

Hello. I was trying to do the same thing as you are, and the only true solution would be afaik to make the excel file an .exe file.

I can provide a link to you if you wish (or just google it). Im unaware if providing links here would be considered inappropriate.

Regards

 

[geno32080]

The only workaround I can think of is to have the excel file opened programatically by a script instead of having it opened by the user

How to procedd:

1- Place the excel file in a hidden location (ie: in a hard to find location) on the user's computer
2- Open Notepad and place the following vbscript code in it:

Set xlapp = CreateObject("Excel.Application")
xlapp.Visible = false
Set Wb = XlApp.Workbooks.Open("[B]PUT_YOUR_EXCEL_FILE_FULL_PATH_NA_NAME_HERE[/B]")

3- After writing the correct excel file path in the above script, save the vbscript with the .VBS extension in the same hidden location as that of the excel file
4- Create a shortcut to the VBS file and place it in the user's desktop (You can change the shortcut icon to show the excel icon by right clicking it and choosing Properties/Shortcut tab/Change Icon button)

Now, in order for the user to open the excel file , he/she will have to click on the vbscript shortcut located on the desktop and the latter will take care of opening the excel file without showing the excel splashscreen or the workbook - Just the userform will be on display..

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