Fix Greyed-Out Design Mode in Excel 2016
Question details
The user needs to restore access to Design Mode in Excel 2016 to work with ActiveX controls.

- 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.
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.
Repair Microsoft Office to Restore Design Mode
Use Office repair when Design Mode remains unavailable and an Office installation issue may be responsible.
Close Excel, then open Control Panel and select Programs > Programs and Features.
Select Microsoft Office 2016 in the program list and click Change.
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.
Restart Excel, open the workbook, and check Developer > Design Mode. Open Developer > Visual Basic to check whether the Visual Basic editor also works.

Check Workbook and ActiveX Restrictions
Check these restrictions if the issue occurs in a particular workbook or a managed Office installation.
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.

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.




