VBA & Macro Problems

Fix Excel 2016 Crashes When Opening VBA or Inserting a Module

Anum MushtaqAnum Mushtaq Nov 22, 2026 869 views

Question details

The user needs to stop Excel 2016 from crashing when opening the VBA editor or inserting a module.

Product
Microsoft Excel 2016
Device & OS
Windows 10
Scenario
The user wants to open Visual Basic or insert a VBA module in Excel.
Observed behavior
Excel crashes immediately when opening Visual Basic or inserting a module, even after Office repair and updates.
Before you start

Close Excel before changing Windows settings or testing Safe Mode. Note whether the crash happens in every workbook and whether Office has already been updated and repaired.

Solution 1Recommended

Turn Off the Windows UTF-8 Beta System Locale

Check this Windows setting first if Excel crashes when you open or use the VBA editor.

1
Open Region settings

Open Control Panel, select Region, and then select the Administrative tab.

2
Change the system locale

Select Change system locale and clear the checkbox labeled Beta: Use Unicode UTF-8 for worldwide language support, if it is selected. Select OK.

3
Restart and test VBA

Restart Windows, open Excel, press Alt+F11, and try Insert > Module in the Visual Basic editor.

Turn Off the Windows UTF-8 Beta System Locale
System-wide setting: Changing the system locale can affect how some non-Unicode applications display text. If the checkbox was already clear or the crash continues, test Excel in Safe Mode.
Free Microsoft Office alternative

Work on Spreadsheets in WPS Office While Troubleshooting Excel

WPS Office is a free, lightweight alternative with a familiar interface for working with Office files. Open compatible spreadsheets in WPS while troubleshooting Excel; it does not repair Excel or guarantee compatibility with every VBA macro.

Open and edit spreadsheets while investigating the Excel VBA crashCompatible with Microsoft Excel formats such as XLSX and XLSFamiliar spreadsheet interface makes migration easierFree and lightweight Office alternative
microsoft office alternative - wps office

Frequently Asked Questions

Where do I find the UTF-8 system locale setting?

In Windows 10, open Control Panel > Region > Administrative > Change system locale. Clear Beta: Use Unicode UTF-8 for worldwide language support if it is selected, then restart Windows.

What does it mean if Excel still crashes in Safe Mode?

A crash after starting Excel with Windows+R > excel /safe makes an add-in less likely to be the cause. Check the Windows system locale and consider reviewing Office bitness and compatibility.

How can I check whether Excel 2016 is 32-bit or 64-bit?

Open Excel and select File > Account > About Excel. The version information identifies the installation as 32-bit or 64-bit.

Will switching from 64-bit to 32-bit Office fix the VBA crash?

It may help in some cases, but it is not guaranteed. Check your add-ins and VBA code for architecture requirements before uninstalling and reinstalling Office.