通过

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:

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

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 receive 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?"

 

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
    I've been trying to get VBA to work with Office 2013 on a clean system and, in fact, I can write VBA coded but when I restart I get "An error occurred while attempting to verify the VBA project's signature. Macros will be disabled. Of course I tried full repair and deleting the OTM file. Don't know if this relates to the Excel problems but what is most frustrating is that I can't find any error log or trace to diagnose the problem.

  • Anonymous
    April 28, 2013
    The comment has been removed

  • Anonymous
    August 10, 2013
    Why has VBA has stopped working in Excel 2013 and I get this error message This workbook has lost its VBA project, ActiveX controls and any other programmability-related features. Each time I try opening projects

  • Anonymous
    October 21, 2013
    I am having trouble running a macro in Project 2013. When I create a new project in 2013 my macro will not work properly, but when I open a project created in a previous version it works fine, even when opening in 2013. I enabled all macros in security but am not sure why it wouldn't work. Any suggestions?

  • Anonymous
    January 19, 2014
    I have a problem that seems to be very similar but it appears in a different way. I installed Office 2013 via a HUP streaming installation. Today I wanted to create a macro, but the buttons where greyed out as mentioned above. So I tried reinstalling Office which worked fine. When I got the notification that I can begin to use the programs but Office is still being installed in the background I can start up Excel and create/modify my macro's. But when the installation is complete the buttons are disabled/greyed out again (?!) and I get the mentioned notitfications when opening workbooks containing macro's.