VBA & Macro Problems

How to Fix Excel VBA Editor Font Size Not Saving

Anum MushtaqAnum Mushtaq Nov 2, 2026 869 views

Question details

The user is unable to permanently change the font size in the Excel VBA Editor because the setting reverts to 8pt immediately after closing the Options window.

How to Fix Excel VBA Editor Font Size Not Saving
Product
Microsoft Excel
Device & OS
Windows
Scenario
Attempting to increase the font size in the Excel VBA Editor for better readability and coding comfort.
Observed behavior
The font size changes temporarily but resets to 8 immediately after the Options dialog is closed. Adjusting Windows display scaling from 100% to 125% does not resolve the issue.
Before you start

Before modifying display settings or Windows Registry keys, ensure your Windows operating system and Microsoft Office installation are fully updated to rule out known compatibility bugs.

Solution 1Recommended

Adjust Windows Screen Resolution Settings

Modifying the overall screen resolution rather than just the display scaling percentage is proven to resolve the VBA editor's failure to save font settings.

In many cases, the Excel VBA Editor struggles to save formatting configurations when it conflicts with custom Windows scaling percentages (like 125%). Adjusting the core screen resolution forces the application to re-render and successfully write the font settings.

1
Open Windows Display Settings

Right-click on an empty space on your Windows desktop and select 'Display settings' from the context menu.

2
Change the Display Resolution

Scroll down to the 'Display resolution' dropdown menu and temporarily select a different standard resolution (e.g., 1920x1080).

3
Apply Font Settings in VBA

Open Excel, press Alt + F11 to open the VBA Editor, navigate to Tools > Options > Editor Format, and change the font size. Click OK.

4
Revert Screen Resolution

Once the font size is successfully saved and applied, you can return to your Display Settings and change your resolution back to the original recommended value.

Adjust Windows Screen Resolution Settings
Settings Saved: The font size should now persist across different Excel sessions, even after reverting your screen resolution.
Free Microsoft Office alternative

Experience a Smoother Workflow with WPS Office

Tired of dealing with legacy bugs like the VBA Editor refusing to save your preferences? WPS Office offers a lightweight, free, and highly compatible alternative to Microsoft Office. Enjoy seamless spreadsheet management without the recurring interface glitches.

  1. 1. Download and Install: Visit the official WPS Office website and download the free installation package for your operating system.
  2. 2. Open Your Spreadsheets: Launch WPS Spreadsheet and open your existing .xlsx or .xlsm files seamlessly without worrying about formatting loss.
  3. 3. Enjoy a Modern Interface: Navigate the intuitive ribbon interface to manage your data, utilize advanced formulas, and customize your workspace effortlessly.
Excellent compatibility with Microsoft Excel formats (.xlsx, .xls, .xlsm)Lightweight installation with fast startup timesModern, user-friendly interface with fewer legacy bugsRobust support for advanced spreadsheet functions and data analysis
microsoft office alternative - wps office

Frequently Asked Questions

Why does my Excel VBA font size keep resetting to 8?

This is often caused by a glitch in how the VBA Editor interacts with Windows display scaling or screen resolution settings. It can also occur if the Excel application temporarily lacks the registry permissions required to save UI changes.

Can I change the VBA Editor font size using the Windows Registry?

Yes. VBA settings are stored in the Registry under 'HKEY_CURRENT_USER\Software\Microsoft\VBA'. Deleting the VBA registry key or manually adjusting values can sometimes force the application to reset and save new settings properly, but it should be done with caution.

Does changing Windows scaling to 125% fix the VBA font issue?

For some users, adjusting display scaling fixes UI issues, but in many cases reported by users, the font size still resets. Adjusting the actual screen resolution temporarily is often a more effective workaround.

How do I access the Options window to change the font in the VBA Editor?

Open the VBA Editor by pressing Alt + F11 in Excel. Next, click on 'Tools' in the top menu bar and select 'Options'. Navigate to the 'Editor Format' tab, where you can adjust the font face, size, and colors.