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

You can only enter or delete data in the unlocked cells of a protected sheet.
You cannot change the settings without unprotecting. The protection is to
prevent that type of change without the owner's knowledge.

"Gary Keramidas" wrote:

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