How can I merge unlocked cells in a worksheet that has been protec

[Guest]

In my worksheet, I turned on "Protect Sheet" so that users can't view or
modify locked cells.

But since I still wanted them to be able to modify unlocked cells any way
they wanted, I selected all the options in the list of "Allow all users of
this worksheet to" features in the "Protect Sheet" dialogue box (except for
"select locked cells" obviously).

However, the users can't seem to merge unlocked cells. Is there a way of
including this functionality in the allowed actions?

 

[Debra Dalgleish]

You could create a macro to unprotect the sheet, merge the selected
cells, and reprotect the sheet.

But I'd be happy that they can't merge cells. Merged cells can create
problems in a worksheet.

 

[Dave Peterson]

I, too, hate merged cells and I do my best not to use them.

But you could give the users another worksheet with a merged cell on it (same
dimensions that you need).

Then tell them to copy|paste special|formats to the "real" sheet.

(In fact, some of your users may figure this out for other formatting and really
cause you heartache!)