Disable Excel Background Error Checking for Workbook Users with a Macro
Question details
The workbook owner wants to automatically disable Excel background error checking for users who open the workbook.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A shared workbook has validation cells that depend on other input cells.
- Observed behavior
- Excel displays green error indicators in the validation cells.
Make sure the workbook can be saved as a macro-enabled file and that users can run trusted macros in their Excel environment. The setting affects the Excel application, not just this workbook.
Run an Auto_Open Macro to Disable Background Error Checking
Use this macro to turn off background error checking when a user opens the workbook and allows its macros to run.
The macro changes an application-level Excel setting, so it can affect other workbooks open in the same Excel instance. It does not automatically restore the previous setting when the workbook closes.
This approach cannot guarantee the change for every user: macros may be blocked or disabled, and Auto_Open does not run automatically when a workbook is opened programmatically.
Open the workbook in Excel, then open the Visual Basic Editor from the Developer tab or with Alt+F11 on Windows.
In the VBA editor, select the workbook project, choose Insert > Module, and enter: Sub Auto_Open() Application.ErrorCheckingOptions.BackgroundChecking = False End Sub
In Excel, choose File > Save As and select Excel Macro-Enabled Workbook (*.xlsm).
Close and reopen the saved workbook in Excel. If prompted, enable macros only after confirming the file is trusted, then check that background error indicators no longer appear.

Work with Excel Spreadsheets in WPS Office
WPS Office is a free, lightweight alternative with a familiar interface and Microsoft Office format compatibility, making it easy to move spreadsheet work between suites. It does not change Microsoft Excel's background error-checking setting, and VBA macro support may vary by version.

Frequently Asked Questions
Why do green triangles still appear after I open the workbook?
The macro may not have run because macros were disabled or blocked. Reopen the trusted XLSM file and check for Excel's security prompt. Auto_Open also does not run automatically if the workbook is opened programmatically.
Does the macro disable error checking for only this workbook?
No. Application.ErrorCheckingOptions.BackgroundChecking changes an Excel application-level setting, so it can affect other workbooks in the same Excel instance.
How can I turn background error checking back on?
In Excel for Windows, go to File > Options > Formulas and select Enable background error checking under Error Checking. The menu location may differ on other platforms.
Can I save the macro in an XLSX file?
No. Use File > Save As and choose Excel Macro-Enabled Workbook (*.xlsm) to retain the VBA macro.
Will the setting return to its previous value when I close the workbook?
Not with the Auto_Open macro shown here. It turns background checking off but contains no instruction to restore the previous setting.




