ErrorCheckingOptions.UnlockedFormulaCells Property

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.

Visual Basic for Applications
`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`

unlocked unlocked formula cells unlockedformula unlockedformulacells unlockedformulacells property

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.