Yep,Got it ,but then still its not allowing me to merge cells and add
hyperlinks etc etc few options its still showing unavailable.Is it
possible to make these also active for the sheet??
Actually Dialog word didnot click .Thanks for the help.
Regards
Divya
Muhammed Rafeek M wrote:

Hi Divya
When you are protecting, you will get a dialogbox, right? on that dialog
box, could you enable(active) "format cells, format columns,..." if you
active, it will allow all users

for more help:

"sanam" wrote:

How can I have formatting options like merge cells ,Making Bold etc
active for the unlocked cells of the protected worksheet.Is it possible

in excel?

I locked Few cells of the worksheet and protected it.I want rest all
unlocked cells in the sheet to be allowed to formatted like merging the

unlcoked cells,aligning etc.The moment I protect the sheet the
formatting toolbar gets faded and doesn't allow even the unlocked cells

to be formatted .Is there a way I can allow the unlocked cells of
protected sheet to use the toolbars options??Plz reply if itsnot
possible.....


Regards,
sanam