- This workbook has lost its vba project excel 2016 how to#
- This workbook has lost its vba project excel 2016 plus#
This workbook has lost its vba project excel 2016 how to#
That policy setting assigned a value of 1 to the VBAOFF value in the System Registry, according to Method 3 in How to turn off Visual Basic for Applications when you deploy Office, so you may be able to re-enable VBA by changing the value to 0. Please ask your IT department to remove the policy setting Disable VBA for Office applications. This prevents many Excel features from working, as explained in the articles cited above. If VBA was already set to Run from My Computer, you or your IT department have set a system policy to disable it. Click the drop-down arrow next to Visual Basic for Applications and change it to Run from My Computer.
This workbook has lost its vba project excel 2016 plus#
In the list that appears, click the plus sign to expand Office Shared Features.Select Add or remove features and click Continue.Select Microsoft Office and click Change in the menu at the top, or right-click Microsoft Office and select Change.Open Control Panel » Programs and Features (in Windows XP, Add or Remove programs).To solve the problem, re-enable Visual Basic for Applications: Microsoft's articles Some Excel features are unavailable if you disable Visual Basic for Applications and run Excel and Considerations for disabling VBA in Office explain that this makes some Excel features unavailable, including some native Microsoft Excel add-ins and add-ins from third parties. You have Visual Basic for Applications disabled, either by a policy setting or because it was disabled during installation of Microsoft Office. This workbook has lost its VBA project, ActiveX controls and any other programmability-related features. When I try to launch my Palisade software, I get a pop-up like this oneĮxcel was able to open the file by repairing or removing the unreadable content. "This workbook has lost its VBA project." If you click OK, Excel opens the file in read-only. "This workbook has lost its VBA project."Ģ.86. This workbook has lost its VBA Project, ActiveX Controls and any other programmability-related features.