VBA code to show the start screen when this application starts

[Tazyote]

Good Morning Folks,

I am drawing a complete blank here and I am hoping you can help me out. I have a startup macro for my worksheet that does all the nifty and neat things I need it to with the exception of setting the "show the start screen when this application starts" checkbox in General Options (screen shot included). I am drawing a blank on what to label it. Application.--------- = False. What is this called? Any ideas? Any help would be appreciated. Thanks

Untitled.png

[Norie]

That option is used to display or not display the standard Excel (or other Office application) startup screen.

Are you trying to disable the startup screen so the user sees your own 'startup'?

[Tazyote]

Exactly, I need the VBA code to ensure it is shut off when the workbook is open. The reason why is that the macro sets the workbook at "ignore remote requests", hides the workbook and opens a userform. If someone opens a new Excel worksheet while this is open, it crashes the userform and shuts down Excel. Since there are multiple users, the best way to ensure that does not happen is to include a command to uncheck this setting on activation. Therefore, I am looking for a code to uncheck this box to include in my startup macro. Make sense?

[Norie]

I don't think you can use code to suppress the default splash screen, the only way I can find to do it without going to Options is to use command line switches.

For example.

Please Login or Register  to view this content.

[Tazyote]

Oh, I can see the confusion. No, you can't suppress the default splash screen for the program as it is being opened. I wanted to have the macro set the preference for any new workbooks being opened after this one is already open. I guess my statement of using it in the startup macro was confusing. Sorry about that. Look at it this way, I have a userform with a button. The program is already open and I just want to set the preference. If I wanted that button to turn off the start screen on startup, what code would I need? Should have kept it simple to begin with. Again I apologize.

[Norie]

I don't follow, if you originally open your workbook, and Excel obviously, you will get the default startup/splash screen.

For any subsequent workbooks opened in the same instance of Excel you won't get the startup/splash screen.

If you mean you want to programattically set the option to not show the Excel startup/splash screen then as far as I know it's not possible.

All I can find is workarounds involving things like setting command line switches for shortcuts or opening, and hiding, Excel and the workbook using VBS.

[Tazyote]

How would one go about setting a command line switch? I am unfamiliar with these. Thanks