2007 Excel Headache: Macros

[DHR]

When I try to open my Office '97 Excel spreadsheets in Office 2007 I get a window titled "Repairs to filename.xls" and this msg:

"This workbook has lost its VBA project, ActiveX controls and any other programmability-related features."

I can't see my Macros, let alone run them even though I've enabled them in the Trust Center.

[Calvin K]

You get this error because during the installation of MS Office 2007, "Visual Basic for Application" was not installed.

To solve this you need to change your installation of MS Office.

1. Close Excel if it is open.
2. In the Control Panel choose "Add or Remove Programs" (or Programs and Features in Windows Vista).
3. Select Microsoft Office in the list and click on the Change button.
4. Choose "add or remove features"
5. Select "Visual Basic for Applications" in the "Office Shared Features" list and set it to "Run from My Computer". Then click on the continue button.
6. After the installation is finished you will be able to use ASAP Utilities when you start Excel and see ASAP Utilities in the menu.

[Raiz]

Refer to following thread:

This workbook has lost its VBA project, ActiveX controls and any other programmability-related features.

and to this Microsoft help:

Some Excel features are unavailable if you disable Visual Basic for Applications and run Excel

Hope this will help.

[Sam.D]

I think when you had installed Microsoft Office 2007, it was installed with its default settings and features. As a result, some of its Excel features may not have installed. You can uninstall and then reinstall by selecting proper options during installation.....otherwise just install the VBA component of Excel.....

[DHR]

Worked great. Thanks for the expertise!