Macro Security Settings
»
If you have trouble starting a macro or get the message "Macros in this workbook are disabled....." then you will need to adjust your Excel macro security settings in order to ran a macro. There is one of two reasons why your macros are disabled.
|
Reason One:
»
You clicked "Disable Macros" when this workbook was opened. To resolve this issue close the workbook and reopen it again. This time click "Enable Macros" when prompted. (See Figure 1)
|
(Figure 1)
|
Reason Two:
»
If you didn't get prompted to Enable/Disable Macros when you opened the workbook then your macro security settings are too high to run a macro. In order to run the macro you must set the Excel macro security to medium. To do this follow the steps listed below:
|
Step One
»
In the Excel menu bar click Tools-->Macro-->Security.
|
(Figure 2)
|
Step Two
»
The dialog shown in Figure 3 below should be displayed. On the "Security Level" Tab, change the security settings to "Medium" and click ok. (See Figure 3) With the security settings set to Medium Excel will prompt you to Enable/Disable macros for any workbook that contains a macro.
|
(Figure 3)
|
Step Three
»
Close the Macro workbook and reopen it. When prompted to Enable/Disable macros click "Enable Macros". (See Figure 4)
|
(Figure 4)
|
