Each time when I open an excel file with Macro features. Excel will always delete VBA project, activeX whatever the macro if!!!If I made several modifications on the file,and save it. The Macro code will be lost forever!!!!!!!!!!!!!I have tried to Enable all Macro in trust center, reinstalled office for thousands of times, repaired office for millions of times and tried to delete files un XLSTART folder(no files inside). It's driving me crazy and I need someone to solve this problem as soon as possible!!!

OS: Windows 7 Pro, 64-bit, Traditional Chinese

Office: office 2013 home and business, 32-bit, English

It says:"

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

"

Hi,

If you encounter the above error, you may not have Visual Basic for Applications installed with Excel.

Please confirm by following the steps below:

1. Close Excel if it is open.

2. In the Control Panel choose "Add or Remove Programs" (or Programs and Features in Windows Vista / Windows 7 / Windows 8).

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.

• Did you try creating a new desktop profile or any other user account on the same PC. If you have anyy other PC, does this happen there as well.
• Are you in a workgroup or domain with GPOs impacting this.

How to determine whether VBA is enabled

If VBA is installed, it may be disabled. If one of the following VBAOff DWORD registry keys exists and has a value that is greater than 0, VBA is disabled

Microsoft Office 2013

HKLM\Software\Microsoft\Office\15.0\Common\VBAOff[DWORD] HKCU\Software\Microsoft\Office\15.0\Common\VBAOff[DWORD]

Refer to this article How to turn off Visual Basic for Applications when you deploy Office  and check the reverse to confirm all are set accordingly for VBA to work.

Once all set reboot the PC to confirm the values are not changed.

References:

Error Message: This workbook has lost its VBA project, Active X controls and any
other programmability-related features.

How to determine whether VBA is enabled for Office applications