Applies to: All DTS products

Error:

Repairs to 'Risk.xla'

Excel was able to open the file by repairing or removing the unreadable content.

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

Cause:

This error indicates that the Visual Basic for Applications is disabled, either by a policy setting or because it was disabled during installation of Microsoft Office.

Solution:

Re-enable Visual Basic for Applications:

1. Open Control Panel » Programs and Features
2. Select Microsoft Office and click Change in the menu at the top, or right-click Microsoft Office and select Change.
3. Select Add or remove features and click Continue.
4. In the list that appears, click the plus+ sign to expand Office Shared Features.
5. Click the drop-down arrow next to Visual Basic for Applications and change it to Run from My Computer.
6. Click Continue.

If VBA was already set to Run from My Computer, a system policy has been set to disable it. Please ask your IT department to remove the policy setting. 

• The policy setting is assigned a value of 1 to the VBAOFF value in the System Registry. You may be able to re-enable VBA by changing the value to 0. 
  • The VBAOFF value is located in HKEY_LOCAL_MACHINE\Software\WOW6432Node\Policies\Microsoft\Office\nn.0\Common or HKEY_LOCAL_MACHINE\Software\Policies\Microsoft\Office\nn.0\Common, where nn is 15 for Office 2013, 14 for Office 2010, 12 for Office 2007, or 11 for Office 2013.