As a fulltime developer I oftentimes open files containing VBA and want to be able to run code. At the same time I sometimes want to prevent Workbook_Open event code or an Auto_Open macro from running.
With Excel 97 to 2003, this was simple: hold the shift key when you click “Enable macros”.
With Excel 2007 and [...]
Read More...
Read the complete post at http://www.dailydoseofexcel.com/archives/2009/12/07/preventing-auto_open-and-workbook_open-events-from-running/
Posted
Dec 07 2009, 08:35 AM
by
Daily Dose of Excel