ErrorCheckingOptions.UnlockedFormulaCells Property (Excel)
When set to True (default), Microsoft Excel identifies selected cells that are unlocked and contain a formula. False disables error checking for unlocked cells that contain formulas. Read/write Boolean.
Syntax
expression .UnlockedFormulaCells
expression A variable that represents an ErrorCheckingOptions object.
Example
In the following example, the AutoCorrect Options button appears for cell A3, an unlocked cell containing a formula.
Sub CheckUnlockedCell()
Application.ErrorCheckingOptions.UnlockedFormulaCells = True
Range("A1").Value = 1
Range("A2").Value = 2
Range("A3").Formula = "=A1+A2"
Range("A3").Locked = False
End Sub