Hi,

I receive the following error when trying to lock a cell via a macro -
"Unable to set the Locked Property of the Range class.". My code basically
writes a value into an unlocked cell, unprotects the sheet, changes the cell
to locked, then re-protects the sheet. Code is below:

Range("O73").Select
ActiveCell.FormulaR1C1 = "CHECKED"
ActiveSheet.Unprotect Password:="ABC"
Selection.Locked = True
ActiveSheet.Protect Password:="ABC"

The error occurs at "Selection.Locked" stage. Can anyone help me?????

Thanks,
Richard.