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.