다음을 통해 공유

Office 2013 VBA component stops functioning

  • 아티클

We are seeing a few cases where the VBA component of the Office 2013 apps stop functioning.  The applications are working properly when installed.  Then a few days later VBA buttons no longer work.  Here are the scenarios that we
have seen:

Word

  • The Macro button is not greyed out but when trying to run or record a macro they receive the following
    message, “The function you are attempting to run contains macros or content that requires macro language support"

PowerPoint

  • The Visual Basic, and Macros options are disabled/greyed on the ribbon.
  • When opening presentations with VBA code, the user receives the following message:
    "The document contains macros. Macro language support for this application is disabled. Features requiring VBA are not available. Would you like to open this document read-only?"

Access:

  • When running wizards the receive the following error,  “This feature isn't installed, or has been disabled"
  • When opening VBA editor the user receives “"Microsoft Access is unable to load the Visual Basic for
    Applications dynamic-link library (dll) Vbe7" when opening the Visual Basic Editor (VBE)”

Excel

  • The Visual Basic, Macros and Record Macro options are disabled/greyed on the ribbon.
  • When opening workbooks with VBA code, the user receive the following message, “The Visual Basic for
    Applications (VBA) macros in this workbook are corrupted and have been deleted."

 

In most cases repairing MS Office fixes the issue.  

What we believe is happening is there is a registry cleaner or system maintenance type application removing some our registry keys that we
need for VBA to run successfully.  In the above scenarios when the MS Office application was installed the VBA worked properly.

Comments

  • Anonymous
    January 01, 2003
    We have tried restoring and even uninstalling and reinstalling office 2013/365 to no avail.

  • Anonymous
    January 01, 2003
    Add Outlook to the problem list. Same problem with error loading VBA. I've been unable to use VBA after a clean install of Office 2013 Home Premium. It worked fine on my previous machine where I installed it as an upgrade. If I erase the OTM file I can get VBA to work once and then it fails again so it's not because of security problems nor certificates. Done repairs and reinstalls ...

  • Anonymous
    September 25, 2013
    This is happening on 2 Windows 8/64 Bit Office 2013 systems.  There are no registry keys grayed out.  Other ideas?

  • Anonymous
    December 04, 2013
    I cannot get the VBA code to run from a command button or in the editor. It will not perform any of the code.

  • Anonymous
    August 11, 2014
    I now have a Word Macro that fails to run under service pack 1 of Office 2013. At the momemt it would seem that it takes a recompile of the macro under SP1 to make it work, but still working on this. Anyone see simular issues.

  • Anonymous
    October 20, 2015
    mine was office 2013 on windows 8/64 bit with same problem in ms word. using 'repair-online' from control panel
    worked eventhough repair stopped half-way as online repair programs were 32 bit. yet, my problem of macro does not appear now. document logo of ms word changed from typical blue-lined one to white-lined DOCX.