View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
divya divya is offline
external usenet poster
 
Posts: 26
Default 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