KBA-01496: Programmatic access to the Microsoft Office Visual Basic for Applications project system could not be enabled

Problem:

The following error may be encountered when opening an SOV, BFA or Period Distribution workbook in Microsoft Excel:

Programmatic access to the Microsoft Office Visual Basic for Applications project system could not be enabled

or

The customization assembly could not be found…

Unfortunately, this error is often reported as

Microsoft.VisualStudio.Tools.Applications.Runtime.ControlNotFoundException: This document might not function as expected because the following control is missing:

The dialog with the above message has a Details button, and the actual error is in the details for example:

This document might not function as expected because the following control is missing: Sheet8

Solution:

To resolve this problem:

Please follow the “procedure” outlined in KBA-01519


KBA-01496; Last updated: January 24, 2018 at 15:05 pm
Keywords:  PD, Budget