I've created a spreadsheet with a ThisWorkbook macro that launches when the workbook is opened. At least, that's what it does most of the time. However, I have one client for whom the ThisWorkbook macro doesn't launch. I emailed my client a copy of an earlier version of the spreadsheet and the ThisWorkbook macro launched. Both versions have virtually identical ThisWorkbook macros.

In the newer version of my spreadsheet, the ThisWorkbook macro launches on all of my test computers, but not on this clients computer. So I searched the Internet and found a link where this erratic behavior was also observed.

http://stackoverflow.com/questions/5...snt-always-run

The link references an article that explains this as an Excel bug, but the link no longer works. While the link doesn't work, the author says that this article explains that the ThisWorkbook macro doesn't launch because Excel is busy doing some sort of calculation.

Has anyone else experienced this behavior? And/or can you give me some insight into why or how this happens?