VBA & Macro Problems

Fix Disabled Visual Basic and Macros Commands in Office 2016

Muhammad TalhaMuhammad Talha Nov 14, 2026 868 views

Question details

Restore access to Visual Basic and Macros commands in Excel 2016 and troubleshoot related Word pop-up errors.

Fix Disabled Visual Basic and Macros Commands in Office 2016
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.
Before you start

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.

Solution 1Recommended

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.

1
Start Word in Safe Mode

Press Windows+R, enter winword /safe, and select OK. Check whether the pop-up errors still appear.

2
Disable Word add-ins

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.

3
Test Excel in Safe Mode

Press Windows+R, enter excel /safe, and select OK. Open a workbook and check the Visual Basic and Macros commands.

4
Disable Excel add-ins

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.

5
Identify the conflict

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.

Test Office in Safe Mode and disable conflicting add-ins
The VBA issue may remain: In the reported case, removing add-ins fixed Word pop-ups and Excel startup, but Visual Basic remained disabled. Continue with repair and check for organization-managed restrictions if the commands are still unavailable.
Free Microsoft Office alternative

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.

Open and edit Microsoft Word and Excel formats, including DOCX and XLSXUse a familiar spreadsheet interface for everyday workbook tasksMove common document work between Office suites with minimal adjustmentUse a free, lightweight office suite
microsoft office alternative - wps office

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.