Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

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

Posted on 2013-02-04
2
Medium Priority
?
271 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 2000 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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

580 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