Cannot format Unlocked cell

**BiggSmiles** · 12-08-2011, 08:21 AM

I am using excel 2003. I have locked and unlocked celsl on the same sheet.

I have protected the sheet. I can enter data into the unlocked cells. But I can't

BOLD the text in the unlocked cells.

Is there anyway to allow the user to bold the text in the unlocked cells in a protected sheet?

Thanks,

BiggSmiles

**dilipandey** · 12-08-2011, 08:42 AM

Hi BiggSmiles,

Here's the quick way.. while protecting the sheet, check on the options which says... "Format Cells".
Let me know if this helps.

Regards,
DILIPandey

**BiggSmiles** · 12-09-2011, 04:45 PM

DILIPandey,

Thanks for the reply. "format Cells" is grayed out becuase the sheet is locked. What I need for the user is to beavle to click on the BOLD button adn bold the text.

I have a work around by programming a POPUP menu with options to do the Bolding.

Would really like to do awya with the POPUP menu.

Do you have any idea why cell formatting is turned off on unlocaked cells in a protected Sheet?

Thanks again for your reply.

**dilipandey** · 12-09-2011, 10:53 PM

Hey BiggSmiles,

I believe you missed the key message, below would help you to reach to that:-
you have protected the locked and unlocked the cells at the same time.
you will protect the sheet.
while protecting the sheet, there is an option "Format Cells", check that. This will enable a user to format cells (unlocked cells) when the worksheet is protected. Bold comes under formatting.
done.

Let me know if you still have any queries, I will explain this through a attachment. Thanks.

Regards,
DILIPandey
< click on below 'Star' if this helps >

**BiggSmiles** · 12-10-2011, 08:05 AM

You are correct. I did miss it. Thanks for the knowledge.

Biggsmiles

**dilipandey** · 12-10-2011, 09:03 AM

You are always welcome Biggsmiles

Cheers

Regards,
DILIPandey

< click on below 'Star' if this helps >

**nikre** · 01-29-2013, 11:08 AM

How about if I want to allow users to only format (change color) unlocked cells? If protect with allow formatting cells, I let the locked cells to be formatted also which I dont want.

**dilipandey** · 01-29-2013, 03:10 PM

Hi Nikre,

Welcome to the forum.
Don't post your question in another users' thread. Suggest you to start your own thread and you can include a link of this thread.

Regards,
DILIPandey
<click on below * if this helps>