Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Turn off Excel Background Error Checking on opening the workbook

Tags:

excel

vba

I have an excel workbook was has lots of the green "error checking" triangles.

Is there any way using Excel VBA that I can this off when I open the workbook.

like image 578
Craig T Avatar asked Jan 21 '11 00:01

Craig T


People also ask

What is Enable background error checking in Excel?

Background Error Checking Errors in Excel formulas usually show up as a small green triangle in the top left-hand corner of a cell. If you click in the cell that contains an error, a drop down list is enabled from which you can select the option you require.

How do I turn off error checking in VBA?

To disable syntax checkingChoose Options on the Tools menu. Select the Editor tab. Clear the Auto Syntax Check check box. Choose OK.

How do I turn off workbook open event?

Start Excel Application > Go to File > Recent > Doing this will prevent the Workbook_Open event from firing and the Auto_Open macro from running. Or hold shift key and double click to open the Workbook.


2 Answers

I think this is what you're looking for:

    Application.ErrorCheckingOptions.BackgroundChecking = False
like image 130
Marc Thibault Avatar answered Sep 25 '22 06:09

Marc Thibault


I found the answer that I was after:

Sub Auto_Open()
    Application.ErrorCheckingOptions.BackgroundChecking = False 
End Sub
like image 32
Craig T Avatar answered Sep 22 '22 06:09

Craig T