G
Gary Keramidas
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.
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.