Article ID: 930076 - Last Review: November 16, 2008 - Revision: 2.0 Error message when you click buttons for macros in the Excel 2007 Quick Access Toolbar: "Cannot run the macro"SYMPTOMSConsider the following scenario. You add a macro to the Quick Access Toolbar in Microsoft Office Excel 2007. Then you close Excel 2007. Later, when you are working in Excel 2007, you click the button for a macro. In this scenario, you receive the following error message: Cannot run the macro 'macroname'. The macro may not be available in this workbook or all macros may be disabled. CAUSEThis behavior occurs when one of the following conditions are true:
RESOLUTIONTo determine whether macros have been disabled, follow these steps:
MORE INFORMATIONFor more information about macro security settings, see Excel 2007 Help.
| Article Translations
|

Back to the top
