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

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,
Divya

divya 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,
> Divya

Hi,

At the moment I don't have so much time so I'll only give a direction
of sollution...

You must work with a page that I call Mirrorpage... this is an
unprotected page to which you direct all your code (formatting options
etc etc...)... then create a page, let's call it Targetpage... then
you copy (paste-special (a complete special link)) Mirrorpage to
Targetpage, then you hide Mirrorpage, then you lock and secure
Targetpage, then you secure the whole workbook... when you run the
program, it commands to the hidden but open sheet Mirrorpage, this
reflects to the protected visible Targetpage which can only be read...

In general it should work, try & experiment

Greetings Baj

You have more replies in .misc.

divya 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,
> Divya

--

Dave Peterson