OBJECT.PROTECTION

Macro Sheets Only

Equivalent to choosing the Protection tab in the Format Object dialog box, which appears when you choose the Object command from the Format menu. Changes the protection status of the selected object.

Syntax

OBJECT.PROTECTION(locked, lock_text)
OBJECT.PROTECTION?(locked, lock_text)

Locked is a logical value that determines whether the selected object is locked or unlocked. If locked is TRUE, Microsoft Excel locks the object; if FALSE, Microsoft Excel unlocks the object.

Lock_text is a logical value that determines whether text in a text box or button can be changed. Lock_text applies only if the object is a text box, button, or worksheet control. If lock_text is TRUE or omitted, text cannot be changed; if FALSE, text can be changed.

Remarks

• You cannot lock or unlock an individual object with OBJECT.PROTECTION when document protection is selected for objects in the Protect Sheet dialog box.
• If an object is not selected, the function returns the #VALUE! error value and halts the macro.
• In order for an object to be protected, you must use the PROTECT.DOCUMENT(, , , TRUE) function after changing the object's status with OBJECT.PROTECTION.

Related Functions

PROTECT.DOCUMENT Controls protection for the active worksheet

WORKBOOK.PROTECT Controls protection for the active workbook

List of Command-Equivalent Functions