Office 2013 VBA component stops functioning

Office 2013 VBA component stops functioning

  • Comments 4
  • Likes

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
  • This is happening on 2 Windows 8/64 Bit Office 2013 systems.  There are no registry keys grayed out.  Other ideas?

  • We have tried restoring and even uninstalling and reinstalling office 2013/365 to no avail.

  • 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 ...

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

Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment