• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 283
  • Last Modified:

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

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
Jerry Paladino
Asked:
Jerry Paladino
1 Solution
 
Rory ArchibaldCommented:
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
 
Jerry PaladinoAuthor Commented:
Thank You Rory!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now