Excel Opens and Closes by itself.

Attached is a spreadsheet that I use to track my weight.

If I open Excel and I navigate to it and launch it, Excel opens and then closes. If I do it a second time the sheet comes up along with the fact that it was improperly closed the last time. I can either accept the displayed copy or choose the "saved" copy. Either way works fine.

If I navigate to the file in windows and double click on it, it opens just fine.

To add one more piece to the confusion: this is Version 8 of the spreadsheet. It is a rebuilt from scratch version of Version 7. The only thing I did was copy in the data. Version 7 had the exact same issues.

Another side issue is that the chart on the right on the weight sheet does not display until you click somewhere on the sheet.

The rest of my spreadsheets work just fine. This issue started about a month ago. For 8 years prior, things worked just fine.

FYI: the only code in the workbook is run on workbook open and it calls this macro to set the axis on the chart.

Please Login or Register  to view this content.

It works fine for me on a Mac. Does it make a difference if you amend the code to:

Please Login or Register  to view this content.

That appears to work. Now the question is, WHY? In theory it should be the same code.

Thanks.

In my experience, it's rarely a good idea to select objects while the workbook is opening (generally best avoided anyway). In fact, if I use code in the Workbook_Open event, I tend to use OnTime to schedule it (even if I just use Now() as the time) so that the workbook is fully loaded before the code tries to do anything.

It's back doing it again. I even put in a two-second delay before calling the subroutine. I'll just work around the issue by launching it from a shortcut instead of a pinned spreadsheet in Excel. That always works.