Office Settings & Configuration

Fix Greyed-Out Design Mode in Excel 2016

Muhammad TalhaMuhammad Talha Nov 14, 2026 868 views

Question details

The user needs to restore access to Design Mode in Excel 2016 to work with ActiveX controls.

Fix Greyed-Out Design Mode in Excel 2016
Product
Microsoft Excel 2016
Device & OS
not provided
Scenario
The user wants to edit ActiveX controls or inspect their code in a workbook.
Observed behavior
Design Mode is greyed out on the Developer tab, preventing the user from editing ActiveX controls.
Before you start

Confirm that the workbook contains ActiveX controls rather than Form controls, which do not use Design Mode. Close other Office applications before starting a repair and ensure you have an internet connection if Online Repair is available.

Solution 1Recommended

Repair Microsoft Office to Restore Design Mode

Use Office repair when Design Mode remains unavailable and an Office installation issue may be responsible.

1
Open Programs and Features

Close Excel, then open Control Panel and select Programs > Programs and Features.

2
Select the Office installation

Select Microsoft Office 2016 in the program list and click Change.

3
Run the repair

Select Online Repair and click Repair if that option is available. For an installation that offers a different repair dialog, select Repair and follow the prompts.

4
Test Excel

Restart Excel, open the workbook, and check Developer > Design Mode. Open Developer > Visual Basic to check whether the Visual Basic editor also works.

Repair Microsoft Office to Restore Design Mode
Repair options can differ: Online Repair is available for some Office installation types. Follow the repair option shown for your installation.
Free Microsoft Office alternative

Work with Excel Spreadsheets in WPS Office

WPS Office is a free, lightweight alternative with a familiar interface for opening and editing compatible spreadsheets. It supports common Microsoft Office formats for an easier move, but it does not repair Excel 2016 or replace Excel's ActiveX Design Mode.

Open and edit Excel-compatible spreadsheets in WPS SpreadsheetsCompatible with common Microsoft Office formats, including XLSX and XLSUse a familiar spreadsheet interface for everyday tasksMove between common Office files with a free, lightweight suite
microsoft office alternative - wps office

Frequently Asked Questions

Why is Design Mode greyed out in Excel 2016?

Workbook restrictions, ActiveX settings, organizational policies, or an Office installation issue may be involved. Check the workbook's editing status and Review tab, then consider repairing Office through Control Panel.

How do I repair Excel 2016?

Close Office applications, open Control Panel > Programs > Programs and Features, select Microsoft Office 2016, and click Change. Choose Online Repair if available, or follow the repair option shown.

Do Form controls need Design Mode?

No. Design Mode on the Developer tab is used for ActiveX controls. Form controls can be edited using their own context menu.

Can WPS Office fix Excel's Design Mode?

No. WPS Office is an alternative for working with compatible spreadsheets; it does not repair Microsoft Excel or provide a replacement for Excel's ActiveX Design Mode.