Disable Error Proofing

Gurus,

I have tried disabling the error proofing to eliminate an annoying error. (Formula Omits Adjacent Cells)

Private Sub Workbook_Open()



    Application.ErrorCheckingOptions
        .BackgroundChecking = False
        .EvaluateToError = False
        .InconsistentFormula = False
        .OmittedCells = False


End Sub
Private Sub Workbook_BeforeClose(Cancel As Boolean)

Application.ErrorCheckingOptions.BackgroundChecking = True

    Application.ErrorCheckingOptions
        .BackgroundChecking = True
        .EvaluateToError = True
        .InconsistentFormula = True
        .OmittedCells = True


End Sub

Please let me know what I am doing wrong.

FIY, I did close the file and reopened it.

TIA,
Tim