Test for Start screen

Is there a way to test for the start screen on Workbook open.
This is from an Add-in.
Or show blank workbook instead.

Untitled.png

Not certain I fully understand your question.

It is probably about such a moment when you open the Excel application (without opening the file). At that moment, all the add-ins indicated in the list are loaded. Since no workbook has been opened (xls, xlsx, xlsm) probably the event procedure in our add-in assumes that a workbook is already open and reports an error.
Just check how many workbooks are open:

Please Login or Register  to view this content.

Unless it is about something else. This is just my guess.

Artik

Oh, very helpful

Thanks Artik, this is what I was referring to.

I've tested by unchecking "Show the Start screen when this application starts" in Excel Options, General.
But still get a count of 0, so the workbook open event seems to be running before the worksheet is shown.

Please Login or Register  to view this content.

Attachment 796758

Attachment 796759

Once again.
When opening Excel, the add-ins are loaded first and then the workbook(s). That is, in the Open procedure in the add-in, you will always get result = 0, because the event occurred even before any workbook was opened.

I suggest, describe exactly the problem you have and what you want to achieve, because perhaps checking "Show the Start screen..." is not the right way.
To check whether the "Show the Start screen..." checkbox is checked, you need to look at the system registry with code.

By the way.
Attach attachments to the forum as described in the yellow banner at the top of the page. Other attachment methods may be unreliable.

Artik

Hi Artik, this is a better description.
So if the Show the Start screen box is checked, there is an error message.
If Excel opens like it used to before in a blank worksheet, then no issues.

ThisWorkbook:

Please Login or Register  to view this content.

module:

Please Login or Register  to view this content.