Can I disable Excel 2013 Start up screen using VBA?

[Sandy573]

I am a noobie with VBA and am wondering if any of you have a solution for my problem. I have a user form with a button that I would like to disable the Excel Start Screen. The problem is that I cannot figure out any code that would do this. The only way I can find to do it is to go into File -> Options -> General -> and manually check or uncheck the box. I would love to automate this as it creates bugs with the macro in other ways when I try to open a new worksheet. Do any of you have some ideas? Any help would be appreciated.

[mdmackillop]

Welcome to VBAX
Check out the first answer here

[Aflatoon]

Perhaps:

Application.ShowStartupDialog = False

[Sandy573]

I appreciate the ideas but the first one is not quite what I need as it does not run a macro to automatically turn off the Show Start Screen (I would have to rely on individuals to do this which would create issues) and the second solution does not work. I tried this earlier and I believe it is to prevent some sort of pop up on opening but I am not sure. I am not convinced there is a way to do this using VBA but I appreciate your efforts and ideas. I will probably just have to deal with the people as they crash excel one at a time and stress that they need to uncheck this box for the macro to operate correctly. Thanks :-)