Solved

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

Posted on 2013-02-04
2
226 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

914 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

22 Experts available now in Live!

Get 1:1 Help Now