Hi Jimbob,

After searching this group for keywords "assign cell value to
variable" and "unprotect", I found these.

you could assign value to variable like:
myValue = Range("A2")

You may need to unprotect the sheet first:

Sheets("SheetName").Unprotect "PassWord"

And then protect the sheet:

Sheets("SheetName").Protect "PassWord"

A clearer description of your goals may generate a more complete
response.

HTH

Dan