VBA Missing from Excel 2016 RRS feed

  • Question

  • Hi 

    Installed Brand New Office Home & Stud & Excel 2016 but there is NO VBA. 

    I just get Debug errors running any kind of code.  

    Installed the 64 & 32 Bit Excel 2016.  

    How do I get VBA loaded in this Excel?  


    Wednesday, September 6, 2017 9:02 PM

All replies

  • Hi,

    hope this helps:

    Wednesday, September 6, 2017 9:09 PM
  • Hi,

    In the VBA editor, go to  Tool | References and uncheck any libraries marked as Missing.

    Wednesday, September 6, 2017 9:12 PM
  • Hi,

    If you cannot find VB Editor, 
    1) [File] > [Options] > [Customize Ribbon]
    2) check [Developer]
    3) you can find Developer tab on menu ribbon

    If I misunderstand your question, please explain more details about your issue.



    Wednesday, September 6, 2017 10:15 PM
  • Hi,

    Please check if the information of Ashidacchi was helpful.

    Do you use MSI installer to install Office in your environment? If yes, please go to Control Panel- Programs and Features- right click Office and select Add feature, please check if you don't install VBA editor in advanced features, please check the VBA editor and install it.

    Please let us know if you would like further assistance. 

    Emi Zhang
    TechNet Community Support

    Please remember to mark the replies as answers if they helped.
    If you have feedback for TechNet Subscriber Support, contact

    Friday, September 8, 2017 8:39 AM