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.
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.
To disable syntax checkingChoose Options on the Tools menu. Select the Editor tab. Clear the Auto Syntax Check check box. Choose OK.
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.
I think this is what you're looking for:
Application.ErrorCheckingOptions.BackgroundChecking = False
I found the answer that I was after:
Sub Auto_Open()
Application.ErrorCheckingOptions.BackgroundChecking = False
End Sub
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With