Allow format cell with protected worksheet

**graiggoriz** · 10-31-2013, 09:40 AM

Hello,

I need to protect an excel file but let users to change the format cell that are not locked.

I have a "description" field that I need to unlock and let users change the font, bold the text etc..

From Excel 2010, when I go to Review, Protect Sheet: If I tick "Select locked cells", "Select unlocked cells" and "format Cells". It do allow the users to change the format cell but the other protected cells with formulas are not protected anymore.

so far I have used the workaround to run my macros:

HTML Code:

and I only had "Select locked cells", "Select unlocked cells" from the menu Review, Protect Sheet.

Can you please tell me if there is any way / work around or solution ??

Thanks,
graig