Fix Disabled Visual Basic and Macros Commands in Office 2016
Question details
Restore access to Visual Basic and Macros commands in Excel 2016 and troubleshoot related Word pop-up errors.

- Product
- Microsoft Office Home and Student 2016
- Device & OS
- Windows; version not provided
- Scenario
- The user wants to use VBA and macros in Excel while resolving Word startup pop-ups.
- Observed behavior
- Excel's Visual Basic and Macros commands are disabled, and Word displays pop-up errors. Removing conflicting add-ins resolved some symptoms, but Visual Basic remained disabled in Excel.
Close open Office files and note which Word templates and Excel add-ins are installed. Check whether the disabled commands are still unavailable after opening a workbook in Excel.
Test Office in Safe Mode and disable conflicting add-ins
Use Safe Mode to check whether an add-in or template is causing the startup errors or disabled commands.
Press Windows+R, enter winword /safe, and select OK. Check whether the pop-up errors still appear.
In Word, open File > Options > Add-ins. Choose COM Add-ins in the Manage list, select Go, clear the suspected add-ins, and select OK. Check other relevant entries in the Manage list, including Templates, for conflicting items such as a Mendeley template.
Press Windows+R, enter excel /safe, and select OK. Open a workbook and check the Visual Basic and Macros commands.
In Excel, open File > Options > Add-ins. Select Excel Add-ins or COM Add-ins in the Manage list, select Go, and clear suspected add-ins, such as a SAS add-in. Restart Excel normally and test again.
If the problem clears, return to File > Options > Add-ins and re-enable items one at a time, restarting the application as needed to identify the conflicting add-in.

Reset the Word Normal template
Try this if Word pop-ups persist and a damaged default template is suspected.
Repair the Office 2016 installation
Use Office repair if add-in and template checks do not resolve the problem.
Work with Office documents in WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for working with Word and Excel files. Its format compatibility makes it easier to move everyday document work between suites, though it does not repair Microsoft Office's disabled VBA commands.

Frequently Asked Questions
Does Office Home and Student 2016 include VBA?
The desktop edition includes VBA support, so the edition alone does not explain disabled commands. Check add-ins, the Office installation, and any policies managed by your organization.
How do I open Excel without loading add-ins?
Press Windows+R, enter excel /safe, and select OK. If Excel works differently in Safe Mode, review add-ins under File > Options > Add-ins.
Where are macro security settings in Excel 2016?
Open File > Options > Trust Center > Trust Center Settings > Macro Settings. These settings control macro security; changing them does not necessarily restore a disabled Visual Basic command.
What happens when I rename Normal.dotm?
Word creates a new default template when it next starts. Customizations stored in the renamed template are not automatically transferred, so retain the old file if you may need them.
Can WPS Office fix disabled VBA commands in Microsoft Excel?
No. WPS Office is an alternative for working with Office files, but it cannot repair Excel's installation or policies. VBA and macro compatibility may differ between the applications.




