VBA & Macro Problems

Fix Excel VBA Find and Replace Not Working on macOS

Tauseeq Magsi Sep 28, 2026 868 views

Question details

The user is unable to use the Find and Replace feature within the Excel VBA Editor on macOS because the dialog box closes immediately without executing the search.

How to Fix Excel VBA Find and Replace Not Working on macOS

Product: Microsoft Excel for Mac
Device & OS: macOS (Apple Silicon M2 mentioned)
Scenario: Attempting to search for or replace code strings within VBA scripts, user macros, or the PERSONAL.XLSB file.
Observed behavior: The Find and Replace dialog closes abruptly without searching. This behavior affects both Excel and Word VBA editors.

Before you start

Ensure your Excel workbooks and macros are saved, and check which primary language your macOS is currently using in your System Settings.

Solution 1Recommended

Align macOS and Office Language Settings

Mismatching language settings between macOS and Microsoft Office can cause the VBA editor dialogs to crash or close unexpectedly.

In many cases, if the macOS system language differs from the spelling or interface language used in Microsoft Office applications (such as using French spell checking while the system is in English, or vice versa), the VBA Editor fails to render the Find and Replace dialog correctly.

Open System Settings

Click the Apple menu in the top-left corner of your screen and select 'System Settings' (or 'System Preferences' on older macOS versions).

Navigate to Language Settings

Go to 'General' and click on 'Language & Region'.

Set the Primary Language

Under 'Preferred Languages', drag English (or the primary language you use in Office) to the top of the list to set it as the primary system language.

Restart and Test

Restart your Mac, open Excel, launch the VBA Editor, and attempt to use Find and Replace again.

Align macOS and Office Language Settings

Language Synchronization: Matching your OS language with your Office language typically resolves this specific VBA Editor crash entirely.

Solution 2

Boot macOS in Safe Mode to Isolate the Issue

Starting your Mac in Safe Mode helps determine if background applications or system caches are interfering with Office.

Free Microsoft Office alternative

Experience a Stable and Lightweight Office Suite with WPS Office

If you are frustrated by troubleshooting Excel VBA editor crashes and language compatibility issues on your Mac, consider switching to WPS Office. It provides a seamless, highly compatible, and lightweight alternative to Microsoft Office.

1. Download WPS Office: Visit the official WPS website and download the macOS installation package.
2. Install the Application: Open the downloaded file and drag WPS Office to your Applications folder.
3. Open Your Spreadsheets: Launch WPS Spreadsheets and seamlessly open your existing Excel workbooks.

Fully compatible with Microsoft Excel (.xlsx, .xls, .csv, .xlsm) formats.Lightweight design ensures fast startup and smooth operation on macOS.Familiar user interface requiring no steep learning curve.Reliable spreadsheet tools for complex data analysis without unexpected crashes.

microsoft office alternative - wps office

Frequently Asked Questions

Why does the VBA Find and Replace dialog close instantly on my Mac?

This usually happens due to a localization or language mismatch between your macOS system settings and Microsoft Office applications. Aligning them to the same language typically resolves the crash.

Where are my personal Excel macros stored on a Mac?

They are typically stored in the PERSONAL.XLSB file, which is usually located at ~/Library/Group Containers/UBF8T346G9.Office/User Content/Startup/Excel/.

Does Safe Mode fix the Excel VBA editor issue?

Safe Mode can help isolate the issue by disabling third-party apps and clearing caches. However, if the root cause is a language setting mismatch, Safe Mode alone will not fix the problem.

Excel & Data Problems