Skip to main content

Error: The function you are attempting to run contains macros or content that requires macro language support.


"Error: The function you are attempting to run contains macros or content that requires macro language support."
Solution:>>
This Error “Error: The function you are attempting to run contains macros or content that requires macro language support.____” pops up after closing the office application like outlook/word/excel etc.

Resulation: 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 Disable 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.
      2. Click OK in the Trust Center dialog box to apply the new setting. Click OK to close the program options dialog box.
      3. Close the file and the Microsoft Office program that you are using.
      4. 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.
      5. 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.
      1. 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.
      1. Close the file and the Microsoft Office program that you are using.
      1. 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."
Resulation : 2:

Actually, this error seems to go 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.
Please Leave your Valuable comments.



Comments

Popular posts from this blog

How to display the location of the current file on the Quick Access Toolbar in Office 2013

 Problem  How to display the location of the current file on the Quick Access Toolbar in Office 2013 Solution You can display the location of the currently open Office document on the Quick Access Toolbar. To do this follow these steps: 1. Open any document or a blank document in Word and click the FILE tab. 2. Click Options at the bottom of the options list on the left. 3. On the Word Options dialog box, click Quick Access Toolbar in the options list on the left. 4. To narrow the choices in the list of commands and make it quicker to find the desired option, select Commands Not in the Ribbon from the Choose commands from drop-down list. 5. Scroll down in the list of commands until you find the Document Location command. Select it and click Add to add it to the Quick Access Toolbar. You can move the Document Location command to a different location on the Quick Access Toolbar using the up and down arrows to the right of the list of toolbar commands. 6. Click OK to accept the c...

How to send email force fully using a default account in outlook.

Problem: How to send email force fully using a default account in outlook. Solution: People who use multiple accounts and frequently (accidentally) send using the wrong account, especially if they are sending sensitive documents, as it will almost eliminate accidentally sending email from the wrong account. In Outlook 2010, the registry key is: HKEY_CURRENT_USER\Software\Policies\Microsoft\Office\14.0\outlook\options Value Name: ForceAccountSelection Value type: REG_DWORD: 1 for force, 0 to disable. In Outlook 2013, the registry key is: HKEY_CURRENT_USER\Software\Policies\Microsoft\Office\15.0\outlook\options Value Name: ForceAccountSelection Value type: REG_DWORD: 1 for force, 0 to disable. Notes: You need to create the path if it does not exist. The value type is the same for both 32-bit and 64-bit Outlook.

How to change the color of the wavy underline that indicates spelling errors.?

Issue: How to change the color of the wavy underline that indicates spelling errors.? Solution: To change the color of the wavy underline that indicates spelling errors, follow these steps: 1.      Click Start , click Run , type regedit , and then click OK . 2.      Locate and then click the following registry subkey: HKEY_CURRENT_USER\Software\Microsoft\Shared Tools\Proofing Tools 3.      If the SpellingWavyUnderlineColor entry exists, go to step 6. If the SpellingWavyUnderlineColor entry does not exist, go to step 4. 4.      On the Edit menu, point to New , and then click DWORD Value . 5.      In the right pane, type SpellingWavyUnderlineColor . This is the name of the new entry. 6.      In the right pane, double-click SpellingWavyUnderlineColor . 7.      In the Edit DWORD Value dialog box, click Hexadecimal . 8.      In th...