workbook has lost its vba project excel 2007

Select 'Visual Basic for Applications' in the 'Office Shared Features' list and set it to 'Run from My Computer'.

Select Microsoft Office in the list and click on the Change button.

In the Windows Control Panel choose 'Add or Remove Programs' (or Programs and Features in Windows Vista or Windows 7).

To solve you can simply change your installation of MS Office and add this feature. We still don't understand why Microsoft doesn't make this error message more user-friendly and just tells that Visual Basic for Applications isn't installed.

Menu Items, Toolbar Buttons and Shortcut Keys related to VBA.

VBA Projects, XLM Macro Code, and ActiveX Controls.

Without Microsoft Visual Basic for Applications (VBA) several Excel features in the following categories are unavailable: 'Visual Basic for Applications' is needed to run macros and add-ins such as ASAP Utilities. You get this error because during the installation of MS Office, the 'Visual Basic for Application' was not installed.īy default this is installed, but you can uncheck it. This workbook has lost its VBA project, ActiveX controls and any other programmability-related features'

'Repairs to 'ASAP Utilities.xla (of ASAP Utilities.xlam)'Įxcel was able to open the file by repairing or removing the unreadable content. When I start Excel I get the following error message: (incomplete Excel setup) Date: (last updated on March 19, 2021) Repairs to 'ASAP Utilities.xla(m)': This workbook has lost its VBA project.

Workbook has lost its vba project excel 2007