Need to format cell after appling protection.

P

Phil D

I am using Excel '97'. I have protected a worksheet and locked the cells with
formulas. However, I cannot format the 'unlocked' cells to use color after
the protection is applied (even though the particular cell is not checked
'locked' under Format/Cells/Protection. Does anyone have any ideas how to
color an 'unlocked' cell when the sheet is protected?

Thanks,

Phil
 
F

fredg

I am using Excel '97'. I have protected a worksheet and locked the cells with
formulas. However, I cannot format the 'unlocked' cells to use color after
the protection is applied (even though the particular cell is not checked
'locked' under Format/Cells/Protection. Does anyone have any ideas how to
color an 'unlocked' cell when the sheet is protected?

Thanks,

Phil
Click to expand...

If you have protected the worksheet, simply un-protect it, make your
changes, and then protect it again.
Anyway ...
You have posted this message to the wrong news group.
The access in this newsgroup's title refers to Microsoft Access, a
database product.
 
Top