i have some cells i have unlocked.

when i protect the worksheet, i can clear the unlocked cells
i can put values in the unlocked cells
but when i try to set the numberformat, it fails, "unable to set the format
property of the range class".
..NumberFormat = "#,##0.00"

unprotect the sheet, it works fine. and i know it's accessing the unlocked cell,
because if i step through, i can see the format change.





--


Gary