Automation Error. Exception Occurred when running a macro
<p>I've recently been having issues running macros on one computer running Excel 2010 on Windows 7 Professional. Whenever I try to run a macro, I get an indefinite progress bar with a message 'Please wait...' and the workbook grays out slightly in the background. After a period of time, I get the error <code>Automation Error. Exception occurred</code> and the workbook closes.</p>

<p>For all intents and purposes, the specific macro doesn't seem to matter, as I've written basic <code>MsgBox Hello World</code> scripts and they throw the same error.</p>

<p>What's unique is that I do not get this error if I either (1) run the macro from within the VBE, or (2) have the VBE open in the background. It seems that having the VBE open allows me to run macros.</p>

<p>I've done some searching and haven't found any solutions that matched my situation. I'd appreciate any help.</p>