How to Fix Excel VBA Editor Font Size Not Saving
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.

- 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 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.
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.
Right-click on an empty space on your Windows desktop and select 'Display settings' from the context menu.
Scroll down to the 'Display resolution' dropdown menu and temporarily select a different standard resolution (e.g., 1920x1080).
Open Excel, press Alt + F11 to open the VBA Editor, navigate to Tools > Options > Editor Format, and change the font size. Click OK.
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.

Run Excel as Administrator to Save Registry Changes
Launch Excel with elevated permissions to ensure the VBA Editor has the necessary rights to write your font size preferences to the Windows Registry.
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. Download and Install: Visit the official WPS Office website and download the free installation package for your operating system.
- 2. Open Your Spreadsheets: Launch WPS Spreadsheet and open your existing .xlsx or .xlsm files seamlessly without worrying about formatting loss.
- 3. Enjoy a Modern Interface: Navigate the intuitive ribbon interface to manage your data, utilize advanced formulas, and customize your workspace effortlessly.

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.




