Hi everyone,
This thread set me thinking about how one would prevent workbook_Open events from running and auto_open macros, whilst at the same time being able to run code.
I discovered the way to do this depends on the Excel version and -especially for Excel 2007 and 2010- isn’t well documented.
See this article for an elaborate explanation on how to do this.