Solved

VBE is Missing from Excel 2007 in a Dual Install of Excel 2007 and Excel 2010

Posted on 2013-02-04
2
216 Views
Last Modified: 2013-02-06
So I have access to both Excel 2007 and Excel 2010, our IT group just installed Excel 2007 and then install Office 2010 on top of it.   Both Excel version work in the User Interface but the VBE is missing from the 2007 version.   In the Developer's tab, the Visual Basic, Macros and Record Macro icons are greyed out.  When I open a file in the 2007 version with macro and enable them, I get a message that says the macros were corrupt and have been deleted.   The 2010 version has the VBE and macros function correctly.

Any suggestions on what may be happening and a way to enable the VBE and macros in the Excel 2007 install would be appreciated.

VBE - Excel 2007
Thanks,
Jerry
0
Comment
Question by:Jerry Paladino
2 Comments
 
LVL 85

Accepted Solution

by:
Rory Archibald earned 500 total points
ID: 38858562
It sounds to me as though they didn't install VBA when they installed the 2007 version. You'll need to do a reinstall and add the VBA component.
0
 
LVL 16

Author Closing Comment

by:Jerry Paladino
ID: 38858916
Thank You Rory!
0

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now