Occasionally, I get calls from clients who don't understand why their Excel file isn't working. They're clicking buttons, or selecting from drop down lists, but none of the usual magic is happening. Is the file broken?

When you open a workbook in Excel 2007, a security warning bar might appear above the worksheet, telling you that macros have been disabled.

Unfortunately, the security bar blends into the Ribbon a little too well, and if you've created the workbook for someone else, they might not even notice the warning.

When I ask my clients with the broken workbooks if they see the warning, usually the answer is yes. A couple of clicks later, the file is working again. It's annoying though, and makes smart people feel not so smart.

Bypass the Security Warning

For Excel workbooks that you know are safe to open, you can bypass the security warning by

Continue reading Bypass the Excel Macro Security Warning