PDA

View Full Version : Can I disable Excel 2013 Start up screen using VBA?



Sandy573
06-22-2016, 11:22 AM
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.

https://support.content.office.net/en-us/media/435bd26c-80f5-4aa3-9efd-b898ebb8c3fd.png

mdmackillop
06-22-2016, 11:39 AM
Welcome to VBAX
Check out the first answer here (http://answers.microsoft.com/en-us/office/forum/office_2013_release-excel/excel-2013-change-default-template/6c6387d0-211c-4f6e-a856-3501324d5098?auth=1)

Aflatoon
06-23-2016, 12:37 AM
Perhaps:

Application.ShowStartupDialog = False

Sandy573
06-30-2016, 01:18 PM
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 :-)