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.



Popular posts from this blog

Setup cannot find office.en-us\dwtrig20.exe during office installation

Problem: 

Setup cannot find office.en-us\dwtrig20.exe during office installation

Solution:

Method 1:

a) Uninstall skype form control panel.

b) After installing office, re-install skype.

Method 2:
a) Browse disk by right clicking on it with mouse.
b) Double click on setup.exe file from the same location.

Method 3:
Note: Take backup of your registry before modifying it. 
For registry backup: open "run" >> type "regedit" >> goto "file" >> click on "export" on desktop.

a) Edit the registry.
HKEY_LOCAL_MACHINE > SOFTWARE > MICROSOFT > OFFICE Delete the keys (items) you find in the OFFICE folder but not the sub-folders. This removes traces of previous installs to avoid possible conflicts when installing the new version of Office.

b)HKEY_LOCAL_MACHINE > SOFTWARE > MICROSOFT > OFFICE > DELIVERY > SOURCEENGINE > DOWNLOADS
Delete the keys (items) you find here.

Excel 2013 right click doesn't work in spreadsheet.

Problem:

Excel 2013 right click doesn't work in spreadsheet.

Solution:

Check if excel works in safe mode.
1. Hold Windows key + R.
2. Copy and paste, or type the following command in the Open box, and then press Enter:
Excel /safe

Note: There is space between Excel and / If Excel safe works, disable the add-ins following steps mentioned below and determine the problem causing add-in: 
Try deleting following key from registry.
Excel 2007. Go to regedit and delete Options entry from HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Excel\ and verify the result.
Note:
• Hold Windows key + R.
• Copy and paste, or type the following command in the Open box, and then press Enter:
regedit
HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Excel\Options
right click on Options and delete it.
Note: Ensure to back up the registry before any modification or deletion.
a) Locate and click the key or subkey that you want to back up.
b) Click the File menu, and then click Export.
c) In the Save in box, select the locati…

your organization's policies are preventing us from completing this action for you. Please contact your help desk.

Error: your organization's policies are preventing us from completing this action for you. Please contact your help desk. Method 1:
Close IE, OutlookInstalling another browser (like Firefox or Chrome)Set it as DefaultClose itOpen IE, let it get set as DefaultClose itNow try Outlook
Method 2: Oepn regedit and modify the defaule values for file associations for.

HeyKeyClassRoot\.htm and HayKkeyClassRoot\.html, the (Default) value change from something like.change the value from ChromeHTML.I2O57VLN4B4DF63FN2NAI4AUOI to "htmlfile".do the same for HKCR\.xht and HKCR\.xhtml  and changed from orphaned Chrome entries to "xhtmlfile" Note: Please take the backup for registry before making any changes in registry.
You can also use the KB article to fix the hyperlink issue in outlook.