'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Fix VBA Editor Font Size Cannot Be Changed in Office 2021
Question details
Users are unable to change or save the font size settings within the VBA Editor in Office 2021.
- Product
- Office 2021
- Device & OS
- Windows
- Scenario
- Attempting to customize the VBA Editor appearance on high-resolution monitors with display scaling enabled.
- Observed behavior
- The font size settings in the VBA Editor fail to apply or save, often reverting back to the default size due to interference from Windows display scaling.
Ensure all Office applications, including Excel and the VBA Editor, are completely closed before adjusting your system's display settings or modifying the registry.
Temporarily Lower Windows Display Scaling
Adjust your Windows display scaling settings to a standard level (100%) before changing the font size in the VBA Editor.
High-resolution monitors and custom Windows display scaling can interfere with the VBA Editor's ability to save formatting settings. Temporarily changing the scaling allows the settings to apply properly.
Make sure Excel, Word, and any other Microsoft Office applications are completely closed to prevent settings conflicts.
Right-click on your Windows desktop and select 'Display settings'. Note your current 'Scale and layout' percentage, then temporarily change it to 100%.
Open Excel, press 'Alt + F11' to launch the VBA Editor. Navigate to 'Tools' > 'Options' > 'Editor Format' and set your desired font size, then click 'OK'.
Close Excel and the VBA Editor. Return to your Windows Display settings and revert the scaling back to your preferred percentage.
Modify the FontHeight Registry Value
Manually edit the VBA Editor registry keys to force a specific font height if display scaling adjustments fail.
Try WPS Office for a Seamless Spreadsheet Experience
If you are frustrated by display scaling bugs and interface issues in Microsoft Office 2021, consider switching to WPS Office. It provides a lightweight, highly compatible alternative with seamless document handling.
- 1. Download the software: Visit the official WPS website and click the free download button.
- 2. Install and open: Install WPS Office and open your existing Excel workbooks directly without format loss.
- 3. Enjoy a stable experience: Experience smooth editing on any high-resolution monitor without UI scaling glitches.
Frequently Asked Questions
Why does my VBA Editor font size keep resetting in Office 2021?
This issue is often caused by a conflict between Office 2021 and Windows high-resolution display scaling. When system scaling is set above 100%, the VBA Editor fails to properly save and retain format changes.
Can I change the VBA Editor font size without changing my monitor scaling?
Usually, no. The most reliable workaround is to temporarily lower your Windows scaling to 100%, apply the font changes in the VBA Editor, and then restore your original monitor scaling.
Does this font size issue affect Microsoft 365 or Office 2019?
While it is most commonly reported in Office 2021 running on Windows 10, similar scaling glitches can occasionally occur in other versions when working across multiple high-resolution monitors with varying scaling percentages.
