Locked Property

Applies To

Arc Object, Arcs Collection, Button Object, Buttons Collection, ChartObject Object, ChartObjects Collection, CheckBox Object, DialogFrame Object, Drawing Object, DrawingObjects Collection, Drawings Collection, DropDown Object, DropDowns Collection, EditBox Object, EditBoxes Collection, GroupBox Object, GroupBoxes Collection, GroupObject Object, GroupObjects Collection, Label Object, Labels Collection, Line Object, Lines Collection, ListBox Object, ListBoxes Collection, OLEObject Object, OLEObjects Collection, OptionButton Object, OptionButtons Collection, Oval Object, Ovals Collection, Picture Object, Pictures Collection, Range Object, Rectangle Object, Rectangles Collection, Scenario Object, ScrollBar Object, ScrollBars Collection, Spinner Object, Spinners Collection, Style Object, TextBox Object, TextBoxes Collection.

Description

False if the object can be modified when the sheet is protected. Read-write.

See Also

FormulaHidden Property, Protect Method, Unprotect Method.

Example

This example unlocks cells A1:G37 on Sheet1 so that they can be modified when the sheet is protected.


Worksheets("Sheet1").Range("A1:G37").Locked = False
Worksheets("Sheet1").Protect