Error Unprotecting Cell

[DYM03]

I am using the line of code below to unprotect a protected cell when a specific value is entered in an input box. I keep getting an object defined or application defined error. I have tried a number of ways to do this but nothing is working. Any help or suggesstions would be appreciated.

Worksheets("MASTER&quot.Range("G43&quot.Locked = False

 

[combo]

The 'Locked' and 'FormulaHidden' properties of range tell excel what to do when worksheet is protected. If both set to true, locked cells can't be changed and formulas are not visible in the formula bar.
They can be changed only when worksheet is not protected.

You need either to set this before you protect worksheet or temporarily unprotect it. You can also protect worksheet with [tt]UserInterfaceOnly:=True[/tt] (this is not saved, so has to be run every time you open the worbook).

combo