Disable background error checking in single workbook but keep on otherwise?

Question

I have a workbook with a necessary formula error on the Master spreadsheet which I have right-click ignored. I need to create a copy of this Master sheet every week and each time it warns me of the error and I have to manually highlight and ignore. How do I disable the Error Checking for this workbook alone but keep it active on all other Excel workbooks?

Answer 1

You are welcome. You can also give feedback on it.

Answer 2

You may try this one.

.IndicatorColorIndex = 2

Answer 3

Alt+F11, Open VBE> Dobule click this workbook> Copy code to it.

Then save the file as macro enable workbook (XLSM) format

Answer 4

Thanks Snow Lu but I don't even know where to start with that code. I'm not quite that advanced with Excel

Answer 5

You may use the solution from HansV MVP, a macro code will turn off error checking when your workbook is opened or activated, and restore the original settings, whatever they were, when your workbook is closed or deactivated.

Turn off error checking on a sheet - Microsoft Community

==========================================================

In the ThisWorkbook module:

Private blnBackgroundChecking As Boolean
Private blnEmptyCellReferences As Boolean
Private blnEvaluateToError As Boolean
Private blnInconsistentFormula As Boolean
Private blnInconsistentTableFormula As Boolean
Private blnListDataValidation As Boolean
Private blnNumberAsText As Boolean
Private blnOmittedCells As Boolean
Private blnTextDate As Boolean
Private blnUnlockedFormulaCells As Boolean
 
Private Sub Workbook_Activate()
    CheckingOff
End Sub
 
Private Sub Workbook_BeforeClose(Cancel As Boolean)
    RestoreChecking
End Sub
 
Private Sub Workbook_Deactivate()
    RestoreChecking
End Sub
 
Private Sub Workbook_Open()
    CheckingOff
End Sub
 
Private Sub CheckingOff()
    With Application.ErrorCheckingOptions
        blnBackgroundChecking = .BackgroundChecking
        blnEmptyCellReferences = .EmptyCellReferences
        blnEvaluateToError = .EvaluateToError
        blnInconsistentFormula = .InconsistentFormula
        blnInconsistentTableFormula = .InconsistentTableFormula
        blnListDataValidation = .ListDataValidation
        blnNumberAsText = .NumberAsText
        blnOmittedCells = .OmittedCells
        blnTextDate = .TextDate
        blnUnlockedFormulaCells = .UnlockedFormulaCells
        .BackgroundChecking = False
        .EmptyCellReferences = False
        .EvaluateToError = False
        .InconsistentFormula = False
        .InconsistentTableFormula = False
        .IndicatorColorIndex = False
        .ListDataValidation = False
        .NumberAsText = False
        .OmittedCells = False
        .TextDate = False
        .UnlockedFormulaCells = False
    End With
End Sub
 
Private Sub RestoreChecking()
    With Application.ErrorCheckingOptions
        .BackgroundChecking = blnBackgroundChecking
        .EmptyCellReferences = blnEmptyCellReferences
        .EvaluateToError = blnEvaluateToError
        .InconsistentFormula = blnInconsistentFormula
        .InconsistentTableFormula = blnInconsistentTableFormula
        .ListDataValidation = blnListDataValidation
        .NumberAsText = blnNumberAsText
        .OmittedCells = blnOmittedCells
        .TextDate = blnTextDate
        .UnlockedFormulaCells = blnUnlockedFormulaCells
    End With
End Sub

===========================================