|
|
Resolution: 1: |
|
|
|
|
To check your macro security settings, click the Microsoft Office Button, click <program name> Options, click Trust Center, and then click Trust Center Settings. |
|
|
|
|
If macro security is set to Disables all macros without notification, all macros are automatically disabled. Use the following procedure to enable the macro. |
|
|
|
|
1. In the Trust Center dialog box, click Macro Settings, and then click Disable all macros with notification. |
|
|
|
|
1. Click OK in the Trust Center dialog box to apply the new setting. Click OK to close the program options dialog box. |
|
|
|
|
2. Close the file and the Microsoft Office program that you are using. |
|
|
|
|
3. Open the file again. A Security Alert appears in the Document Information Bar just below the ribbon. Click Enable Content to allow the macro to run. |
|
|
|
|
4. When you have enabled the macro, it is recommended that you return the macro security setting to Disable all macros without notification. |
|
|
|
|
If macro security is set to Disable all macros with notification, but you selected Disable when prompted by the macro warning dialog when you opened the file, use the following procedure to enable the macro. |
|
|
|
|
1. In the Trust Center dialog box, click Cancel. Click Cancel to close the program options dialog box. |
|
|
|
|
1. Close the file and the Microsoft Office program that you are using. |
|
|
|
|
2. Open the file again. A Security Alert appears in the Document Information Bar just below the ribbon. Click Enable Content to allow the macro to run. |
|
|
|
|
If macro security is set to Disable all macros except digitally signed macros, the macro may not have been digitally signed. Verify that you can trust the macro before using the following procedure to allow it to run. |
|
|
|
|
1. In the Trust Center dialog box, click Cancel. Click Cancel to close the program options dialog box. |
|
|
|
|
2. Close the file and the Microsoft Office program that you are using. |
|
|
|
|
3. Open the file again. A Security Alert appears in the Document Information Bar just below the ribbon. Click Enable Content to allow the macro to run.” |
|
|
|
|
Resolution : 2: |
|
|
|
|
Actually, this error seems to goes away using the “Add or Remove Features” option from the Add/Remove Programs (or Programs and Features in the newer OSes) control panel applet, going to the bottom of the list of available options (Office Tools) and adding Visual Basic for Applications (VBA) option. |
|
|