We love macros, don’t we? Macros make our life easy by automating a particular job – this is how we think about it. We provided couple of macros on Vertical Horizons and we received a great response from our readers. There was a regular query about a macro not working and we thought it would be a good idea to consolidate the possible causes and share with our readers. Here they are:
Incorrect Security Settings
Macros will not run if the Excel security setting is set to High. Go to Tools -> Macro -> Security and set the security level to Medium.
Excel Is In Break Mode
This state occurs when another Macro is already running and either there is some error in the running macro or a break point is set for debugging. To make your macro run, you need to first resolve the issues with the macro that is already running either by fixing it or deleting it or by removing the breakpoint.
Excel Is Password Protected
Most often macros deal with manipulating data in cells. If the excel is password protected, macro may fail to run. Unprotect the excel workbook or excel worksheet and run the macro.
Excel Is In Edit Mode
Excel is in edit mode, when you are editting any cell. When excel is in edit mode, most of the menu options gets grayed out. You need to ensure that excel is not in Edit Mode.
Macros Are Disabled
It may happen that Macros are disabled for the workbook you are working on. For Excel 2003, macros are disabled if security level is set to High. To enable macros in excel 2003, you only need to set the security level to Medium. To enable macros in Excel 2010, you may want to refer this link on troublefixers.com.
Hope you find the information presented here useful. Feel free to leave your feedback or suggestions in the comments section below.