Showing posts with label BI Publisher Add-in. Show all posts
Showing posts with label BI Publisher Add-in. Show all posts

Tuesday, January 22, 2013

BI Publisher MS Word Add-in: The macro cannot be found or has been disabled because of your macro security settings

All of a sudden your MS Word Add-in will quit working with this error message:  The macro cannot be found or has been disabled because of your macro security settings.

Windows Common Control-based embedded ActiveX controls may fail to load within pre-existing Office documents, within third-party add-ins, and when you insert new controls in developer mode. 

This was caused by the MSCOMCTL.OCX file not being registered properly after after an MS Office security update.

You will look on the web and find all kinds of gyrations that they make you do but it is not necessary.  

This is all you have to do:

Note You must run the commands from commands at an elevated command prompt with administrator permissions. To do this, follow these steps:
  1. Click Start, type cmd.
  2. Right-click the cmd icon, and then click Run as Administrator.
  3. Depending on your operating system, type the either of the following commands, and then press Enter:
    • For 64-bit operating systems, type the following:
      Regsvr32 "C:\Windows\SysWOW64\MSCOMCTL.OCX"
    • For 32-bit operating systems, type the following:
      Regsvr32 "C:\Windows\System32\MSCOMCTL.OCX"