VBA & Macro Problems

Disable Excel Background Error Checking for Workbook Users with a Macro

John WilsonJohn Wilson Nov 22, 2026 868 views

Question details

The workbook owner wants to automatically disable Excel background error checking for users who open the workbook.

Disable Excel Background Error Checking for Workbook Users with a Macro
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.
Before you start

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.

Solution 1Recommended

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.

1
Open the VBA editor

Open the workbook in Excel, then open the Visual Basic Editor from the Developer tab or with Alt+F11 on Windows.

2
Insert the macro

In the VBA editor, select the workbook project, choose Insert > Module, and enter: Sub Auto_Open() Application.ErrorCheckingOptions.BackgroundChecking = False End Sub

3
Save as a macro-enabled workbook

In Excel, choose File > Save As and select Excel Macro-Enabled Workbook (*.xlsm).

4
Test the opening behavior

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.

Run an Auto_Open Macro to Disable Background Error Checking
Application-wide setting: Users can turn background error checking back on in Excel's error-checking options. Running the macro again will turn it off.
Free Microsoft Office alternative

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.

Open and edit spreadsheet data in WPS SpreadsheetsWork with Microsoft Excel formats such as XLSXUse a familiar spreadsheet interface for an easier transitionAccess a free, lightweight office suite
microsoft office alternative - wps office

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.