Solved

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

Posted on 2013-02-04
2
251 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
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…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

740 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